February 2, 2010 at 4:24 pm
Forgive me if I'm being a complete Oracle noob here. I am trying to create a linked server in SQL server to an Oracle instance. Here's my specifics
SQL box
Windows Server 2008 64 Bit
SQL Server 64 Bit
Oracle instance
Windows Server 2003 R2 32 bit
Oracle 10g Database
I had installed the 64 bit Oracle client software on the SQL server to try and get the provider, but it wouldn't list it. I've searched around, but nothing I've found really relates exactly to what I'm trying to do. Hoping someone here can educate me as to what I'm doing wrong.
The distance between genius and insanity is measured only by success.
February 3, 2010 at 4:45 am
Setting up a Linked Server in a 64 bit environment requires an additional step.
Please refer to the following link:
http://www.mssqltips.com/tip.asp?tip=1433
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 3:50 pm
Thanks much for the link. That explained it much more clearly! Only one minor issue I'm having now and I'm sure it might be configuration on my part. The linked server appears, but there's no + next to it to expand out. So I'm guessing I have something wrong but I can't determine what exactly. I followed the instructions in the link, with the only difference being using 11g client and ODAC. The 10g 64 bit simply refused to install in our environment.
The distance between genius and insanity is measured only by success.
February 8, 2010 at 3:27 am
Brnbngls (2/3/2010)
. The linked server appears, but there's no + next to it to expand out.
Why would there be any '+' sign for the installed Linked Server. That's your Linked Server setup. Go and test it.
February 11, 2010 at 10:49 am
I was referring to the + next to the server name so you could expand it out and view the catalog, databases, tables, etc.
I actually did finally figure out all of the steps I needed. The origianl link provided helped, but it was missing just a step or two. I've got a procedural doc loaded here for anyone else who might need assistance.
The distance between genius and insanity is measured only by success.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply