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

On Oct 20, 5:57*am, rodrigo <rodrigo.ol... (AT) gmail (DOT) com> wrote:
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

On Oct 24, 5:23*pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote:
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 --