Problem connecting to a remote oracle database using labsql

Larpatin · ‎05-07-2012

Hi all,

I'm trying to connect to a remote oracle 9i database using Labsql but I get "provider cannot be found"-error.

Oracle odbc driver is installed and tested so the connection should be ok.

This is my first time with oracle database (I prefer mysql) so the connection string

can be faulty... help?

Thanks for advance

PS. I'm using windows 7 64-bit with Labview 2011

nyc_(is_out_of_here) · ‎05-07-2012

Larpatin · ‎05-08-2012

I'm using this connection string at the moment:

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

It gives me the "provider cannot be found"-error. The connection string should be right(?).

nyc_(is_out_of_here) · ‎05-08-2012

That connection string that you are using is NOT for ODBC driver.

You can download the OLEDB driver from Oracle's website.

Larpatin · ‎05-10-2012

Looks like my problem wasn't the connection string after all.

After trying connection string with Microsoft oracle driver I got "architecture mismatch"-error,

did some searching and found this:

Probably after installing 32-bit version of oracle client and creating the dsn-connection

using 32-bit version of odbc manager everything should work.

LabVIEW