Re: Connecting through ODBC or OLE DB

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Sat, 24 Oct 2009 14:34:41 -0700 (PDT)
Message-ID: <450bc53b-bed2-4bf3-a9f5-0e4e26c5038c_at_l31g2000vbp.googlegroups.com>


On Oct 24, 5:23 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> 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- 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 -- Received on Sat Oct 24 2009 - 23:34:41 CEST

Original text of this message