September 27, 2010 at 9:47 am
I have a SQL2005 32-bit Server. I installed the Oracle 11gR2 32-bit Client. I then created a LINKED SERVER within SQL2005 to that Oracle database using the "Oracle Provider for OLE DB" PROVIDER. It works great!
Now I have a SQL2005 64-bit Server (Operating System and SQL2005 are both 64-bit). I need to create a LINKED SERVER to that same Oracle database I did on the 32-bit Server.
My question is: do I install the same Oracle 11gR2 32-bit Client on this SQL2005 64-bit Server (like I did on the SQL2005 32-bit Server)? Or do I find a 64-bit Oracle 11gR2 Client to install on my SQL2005 64-bit Server?
...thanks in advance
September 27, 2010 at 11:14 am
Install the 64-Bit Oracle client.
Thank You,
Best Regards,
SQLBuddy
September 27, 2010 at 11:34 am
Thanks for the reply, SQLBuddy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply