LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Attempting to connect to Oracle 8i database

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 progra
m 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
0 Kudos
Message 1 of 2
(3,082 Views)
Chris Bodley wrote:

> 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 wr
itten will not make the 8i connection.
>
> Does anyone have any suggestions or solution? I'd greatly appreciate
> any assistance or information.

If you haven't checked in the NI Example Programs Database, there are at
least two entries that might help you (they refer to Oracle 8 and have some
background info on configuration).

Search for "sql toolkit" from this URL:
http://digital.ni.com/explprog.nsf/$$Search

Regards,
John Lum
National Instruments
0 Kudos
Message 2 of 2
(3,082 Views)