Connecting through ODBC or OLE DB
Date: Tue, 20 Oct 2009 03:57:15 -0700 (PDT)
[Quoted] I'm trying to connect to my databases from a XP box to a HP-UX server with Oracle 10g, either through ODBC or OLE DB. I've tried almost everything and still can't connect to it.
I have both the Microsoft driver and the Oracle driver, and also the Oracle Instant client installed in the XP box, with a tnsnames.ora file that points to the server, ORACLE_HOME variable set up, etc.
I know that it's accesible because I can connect from this same machine with JDBC Oracle Thin Client (ojdbc6.jar). This driver deesn't even need the Oracle client installed in the local machine. I just specified IP, port, SID, user, pass and it works. But the programs I need to use don't support JDBC.
Do you have any connection string that works for you? I've tried the ones in connectionstrings.com and carlprothman.net but I think they're not intended for connecting to a remote server... Received on Tue Oct 20 2009 - 12:57:15 CEST