Oracle Connection

gustavoleo

Hello there

I'm setting up a demo for an oracle database

My connection string looks like that

Provider=OraOLEDB.Oracle;Data;Data Source=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = ****************)(PORT = 1521)) )(CONNECT_DATA =(SERVICE_NAME= ORCL.NEXLUX.LOCAL)));USER ID=****************;PASSWORD=;

And I facing this message

The 'OraOLEDB.Oracle' provider is not registered on the local machine.

Does it require Oracle ODAC components? Any link tips?

It could work with Oracle ODBC?

Thanks in advance!

gustavoleo

I found the solution!

https://devblog.rayonnant.net/2011/04/25/oracle-11g-r2-x64-client-with-odac-installation-guide/

DimitriSorokin

Here is a sample connectino string which I use:
Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=38000))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=)));User Id=;Password="***";

Germo

My experience with Oracle sources: to define the connection string in AC is easy, and it works fine, if Oracle works. It is much more complicated to get the Oracle connection to work (with or without AC), but these are Oracle issues.