We have SQL 05 64 BIT Enterprise edition. Need to connect to a 32bit Oracle 9i database using a linkedserver. When trying to create the linkedserver, it cannot find the ODBC DSN. What needs to be done so the new linked server can access the Oracle ODBC DSN? I have installed Oracle 9i 32 bit client. I am aware of all those 32, 64bit issues. Anyone has a solution for this issue.
asked Dec 28, 2009 at 07:18 PM in Default
Have you installed both 64 bit and 32 bit driver for oracle? My best guess is that you can't see it because you don't have the 64 bit driver.
See quote from http://www.ora600.be/node/4000 below. The page is about SSIS, but if you read the whole page you can see that they moved to linked server later on:
At the bottom you can also see that they needed "Allow InProcess" in the linked server properties.
answered Dec 28, 2009 at 08:57 PM
Please install 64-bit oracle drivers and then you will be able to see OraOledb in the providers option.Please let us know if this solves your issue.
answered Jan 12, 2010 at 11:01 AM