No OLE DB / ODBC drivers in x64

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

No OLE DB / ODBC drivers in x64

Author

Topic

naushi
Starting Member

10 Posts

Posted - 2009-02-13 : 11:03:44

we have an AIX 64 bit machine with windows OS. we have sql server 2005 installed. we are running a package where in we connect to an oracle database. we have installed 64 bit oracle client on the machine. however we get an error while connecting to the oracle database (we did a sqlplus test independantly and it works) our hunch is that it is because of the missing OLE/ODBC driver for 64 bit missing. doing research we found out that such driver does not exist. pl help if you can think of a work around.

MS data link error:

test connection failed because of an error in initializing provider. oracle client and networking components were not found. these components can be suooplied by OIracle Corp and are part of the Oracle version 7.3.3 or laterclient software installation

naushi hussain

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-13 : 11:06:07

Do you have MSDASQL provider in your Linked Server provider list?