Linking SQL Server 64 Bit to Oracle Database

[DBADoug]

Has anyone linked a SQL Server 64 bit database to an Oracle database? I installed the Oracle client software for Windows 2003 64-Bit successfully, but since the current version of SQL 2000 for 64-bit does not use an on server Enterprise Manager, I'm using my 32-bit client PC to manage it, and the Oracle OLE DB Driver is not showing up from my client. Do I have to do the link via Query Analyzer?

Thanks,
Doug

 

[netstructure]

Doug,

you must install a SQL Developer or Standard edition 32 Bit to another PC ( this release can managed the SQL 64 Bit trough Enterprise manager ) and make sure that this is connected to the 64 Bit ( Liberty ) Server. after you have connected to the 64 Bit Server, you can edit the Username and paswort for the 64 Bit SQL to Oracle, and make sure the both sever SQL <---> Oracle are connected.


good luck

antonio

 

[DBADoug]

Thanks ... the problem was that the default client install for the Oracle 64 bit did not have the ole db and odbc drivers. Go figure ... after installing those on the server, it worked just fine.

Doug