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...
> 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...
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.
> On Oct 20, 5:57 am, rodrigo <rodrigo.ol...@gmail.com> wrote:
> > 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...
> 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- 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.