Linkedserver Cannot see Oracle ODBC Driver

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.

more ▼

asked Dec 28, 2009 at 07:18 PM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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:

The method I’ve had the most success with, is to install both the 32- and 64-bit Oracle clients (in separate directories). I’m not sure why you have to have both clients. The only explanation I’ve seen is that part of SQL Server 64 is still 32-bit. I’m not sure if this is true, but if you look at the shortcuts, SSMS and Visual Studio’s EXEs reside in the 32-bit Program Files folder:

At the bottom you can also see that they needed "Allow InProcess" in the linked server properties.

more ▼

answered Dec 28, 2009 at 08:57 PM

avatar image

Håkan Winther
16.6k 38 46 58

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jan 12, 2010 at 11:01 AM

avatar image

26 2 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 28, 2009 at 07:18 PM

Seen: 2290 times

Last Updated: Dec 28, 2009 at 07:18 PM

Copyright 2018 Redgate Software. Privacy Policy