Connecting through ODBC or OLE DB

[rodrigo]

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...

[ora...@msn.com]

You failed to post the error code and message; was there a good reason
for not doing so? Absent such information no one can tell you why the
ODBC/OLEDB connection won't work.

David Fitzjarrell

[Mark D Powell]

> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

rodrigo, the full exact version of Oracle on both boxes and the bit
factor, 32 vs 64, would also be useful information.

HTH -- Mark D Powell --