Re: Attempting to connect to Oracle 8i database

I found my problem. I didn't write the Labview program from scratch myself and there is a filter in a part of the program that wanted a particular host name, which I wasn't giving it. I thought I had checked that earlier.

I appreciate the assistance from the group,

-Chris Bodley

Sybrand Bakker wrote:

> Any tool properly using sqlnet 2 should be able to connect to Oracle 8i,
> provided the tnsnames.ora file still is in the sqlnet 2 directory, (which
> happens to be also the Oracle 8i directory.) Just make sure you have sqlnet
> 2.3 and the required support files 7.3 on your client and it should work.
> If it doesn't work, please post a more exact error message than 'It doesn't
> work'
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> Chris Bodley <bodley_at_odpemail.tamu.edu> schreef in berichtnieuws
> 393BD076.917245E9_at_odpemail.tamu.edu...
> > Has anyone found a way to connect to an Oracle 8i database? I have
> > LabView 5.1 and the SQL Toolkit version 5.0 (which is the latest version
> > of the Toolkit as far as I can tell).
> >
> > The SQL Toolkit includes drivers for Oracle 7, but not 8.
> > Unsurprisingly, with the Toolkit I could connect from an Oracle 7.x
> > client to Oracle 7.x server, but my company is in the midst of upgrading
> > to Oracle 8i and the software now can't establish a connection from the
> > 8i client to the 8i server.
> >
> > I'm fairly certain that my TNSNAMES.ORA file is correct and I've tried
> > several types of entries in my ODBC administrator (different drivers, I
> > mean). SQL*Plus can make a connection, MS Access can make a connection,
> > but the Labview program I've written will not make the 8i connection.
> >
> > Does anyone have any suggestions or solution? I'd greatly appreciate
> > any assistance or information.
> >
> > -Chris Bodley
> >
Received on Mon Jun 05 2000 - 00:00:00 CDT