I have a SQL 2005 server that I need to link to an Oracle server.
I've installed the Oracle client, and followed several sets of instructions found online. I have an error every time I test the connection, telling me that the "Oracle client and networking components were not found."
This is using the MSDAORA provider - when I use the Oracle for OLE DB provider, I get "TNS:could not resolve the connect identifier specified".
I have some knowledge of SQL server, but no real knowledge of Oracle. The setup is: SQL Server 2005 on Windows 2003 (32bit), Oracle 11g on Windows 2008 (64bit).
I also read somewhere that there is a problem connecting a 32-bit server to a 64-bit one. Is this something that could be getting in my way?
What do the errors mean, and what might I be missing to make this all work?