Data link oracle to labview issues.

[StavA]

Hi All,

I tried searching if this issue has been posted previously, but my search came up with nothing. My issue is opening the connection to the oracle database.

Software: Labview 2015, Oracle 12c, Win7 32-bit

What i attempt to do: create a data link in labview for the oracle database.

What happens: I get the error message, "Test connection failed because of an error in initializing provider:[Oracle][ODBC][Ora] ORA-12154: TNS: could not resolve the connect identifier specified", which i then proceeded to look up and attempt to fix using their recommended instructions. My tnsnames.ora file is referenced properly.

It is worth noting that the .udl file that i made works fine when i test the connection when opening it with OLE DB Core Services (opening it outside of Labview). In addition, i can connect to the Oracle database just fine using the command prompt. Therefore database connectivity isn't an issue.

The issue seems to lie somewhere in the labivew/oracle interfacing, otherwise i would have posted this issue to the oracle support forums.

[the_mitten]

Hi StavA,

I've looked at some internal documentation, and here are a few questions and troubleshooting steps to try:

• What provider are you using to connect to the database? Users have been able to resolve issues like this in the past by switching to "Microsoft OLE DB Provider for ODBC Drivers", rather than the Oracle provider. 
• Was your UDL created on a 32-bit machine? Ensure that the UDL has been created using a 32-bit version of the applet
• Is your application connecting to any 64 bit content in Oracle? Verify that all of the content you are trying to access is 32-bit
• Try some of these debugging steps from Microsoft

Finally, here's another user that had the same issue; this user's solution was simply upgrading his version of Oracle installed.

Let me know if any of these steps help!

Regards,