Problem connecting to a remote oracle database using labsql

[Larpatin]

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)]

connectionstrings.com

[Larpatin]

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)]

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

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

[Larpatin]

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:

http://digital.ni.com/public.nsf/allkb/E7984C0DA0F0E65086257694005B4CB7

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

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