Re: Connecting through ODBC or OLE DB
Date: Sat, 24 Oct 2009 14:23:53 -0700 (PDT)
[Quoted] On Oct 20, 5:57 am, rodrigo <rodrigo.ol..._at_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 Received on Sat Oct 24 2009 - 23:23:53 CEST