Re: Attempting to connect to Oracle 8i database

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