x

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 '09 at 07:18 PM in Default

sqldba gravatar image

sqldba
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 '09 at 08:57 PM

Håkan Winther gravatar image

Håkan Winther
15.5k 33 37 48

(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 '10 at 11:01 AM

Chandan gravatar image

Chandan
26

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x101

asked: Dec 28 '09 at 07:18 PM

Seen: 1934 times

Last Updated: Dec 28 '09 at 07:18 PM