Home » Infrastructure » Windows » Error while connecting Oracle 10gr2 on 64 bit windows , from 32 bit windows application
Error while connecting Oracle 10gr2 on 64 bit windows , from 32 bit windows application [message #166961] Mon, 10 April 2006 09:05 Go to next message
preeti_soni
Messages: 3
Registered: April 2006
Junior Member
Hi,

I have installed Oracle 10gr2 in IntelEM 64EMT. The OS is windows 2003 (x64).

I want to connect oracle using 32 bit application.
I already tried SQLConfigDataSource and oledb provided by oracle, however none is successful.

For oledb the connection string I have used is as follows:

pConnection1->ConnectionString =
"Provider='OraOLEDB.Oracle';Data Source='orcl';User Id = 'system';Password='xxxx';";

I am getting error :
Error
Code = 800a0e7a
Code meaning = Unknown error 0x800A0E7A
Source = ADODB.Connection
Description = Provider cannot be found. It may not be properly installed

I have registrered the oracle oledb using following command.

regsvr32 OraOLEDB10.dll

The dll registered successfully. However, I am getting the same error. Please help me.

Thanks and Regards,
Preeti Soni
Re: Error while connecting Oracle 10gr2 on 64 bit windows , from 32 bit windows application [message #260105 is a reply to message #166961] Fri, 17 August 2007 07:56 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
From the Microsoft web site: http://support.microsoft.com/support/kb/articles/Q191/2/71.ASP?LN=3DEN-U=

CAUSE

The MSDASQL OLE DB provider is either unavailable or is not registered. This can be caused by an incomplete upgrade or a bad install of the Microsoft Data Access Components (MDAC) components.

RESOLUTION

Here are two ways to resolve this problem:

Register the Msdasql.dll using the following command: REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"

Reinstall the Microsoft Data Access Components used. The newest version of MDAC can be downloaded from the following Web site:
http://www.microsoft.com/data/download.htm

STATUS

This behavior is by design.
Previous Topic: SQL_Handle_env Failed
Next Topic: access denied
Goto Forum:
  


Current Time: Thu Mar 28 07:44:22 CDT 2024