Connecting through ODBC or OLE DB

From: rodrigo <rodrigo.olmos_at_gmail.com>
Date: Tue, 20 Oct 2009 03:57:15 -0700 (PDT)
Message-ID: <707518bd-3f8c-4d70-ae5f-dba2de80416a_at_z34g2000vbl.googlegroups.com>



[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

Original text of this message