migav
asked on
ODBC driver ORAHOME92 and WINDOWS 2008 R2
Hello !
I have 2 boxes :
a) Windows 2008 R2 with SQL Server Standard Edition 2008 R2 RTM (64bits)
b) Windows 2000 Sp4 with Orahome92 (32 bits)
I have to create a link server in a) to b).
I'm a dba in sqlserver but newbee in oracle.
Where to download the :
a) Client drivers for oracle b) to install in a)
b) Detailed step by step.
Best regards,
Miguel Gavinhos
I have 2 boxes :
a) Windows 2008 R2 with SQL Server Standard Edition 2008 R2 RTM (64bits)
b) Windows 2000 Sp4 with Orahome92 (32 bits)
I have to create a link server in a) to b).
I'm a dba in sqlserver but newbee in oracle.
Where to download the :
a) Client drivers for oracle b) to install in a)
b) Detailed step by step.
Best regards,
Miguel Gavinhos
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I needed to configure the TNS. I was lucky with linked server becuse a collegue had a script to create the linked server.
No, you definitely do NOT need to configure TNS when using EazyConnect («server»/«instance») syntax.
Great answer! Helped me tons!
a) You can download ODBC for W2008r2 here:
http://www.oracle.com/technetwork/indexes/downloads/index.html