Re: Connecting through ODBC or OLE DB

From: fitzjarrell_at_cox.net <oratune_at_msn.com>
Date: Sat, 24 Oct 2009 14:23:53 -0700 (PDT)
Message-ID: <b5b220d6-9f8a-440d-9d71-ffccb9bf5d68_at_31g2000vbf.googlegroups.com>


[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

Original text of this message