ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Connection to Oracle Database with Labview

Solved!
Go to solution

Hi,

I have been trying to connect with an Oracle Database with LabView but I'm still unable after some days. I have read almost all the Post from NI regarding this topic but still did not make it work.

 

I can connect to the database with SQL developer from Oracle, so the connection is good (picture attached).

 

After that I try to connect with ODBC 32 bits driver from Oracle (driver installed: Oracle in instantclient_19_8) , but the configuration is requesting the TNS service, I try to fill this field with the hostname and the service name but did not work, so I suppose I don't have this information.

 

I also try to build the connection string using the samples from connectionstring.com but the OBDC samples request the TNS service, I didn't find an option to use the host and the service.

 

can you give me more guidance to make it work with the information that I have 

 

Regards

LF

 

 

Download All
0 Kudos
Message 1 of 2
(2,199 Views)
Solution
Accepted by topic author LuisFuentes

I just make it work

I had to add the hostname and the service name together in the TNS field

Like this:

 

Hostname/Service name

 

I will close the Post

 

 

0 Kudos
Message 2 of 2
(2,186 Views)