0

We have installed "Oracle Instant Client" and using below connectionstring in our .Net application which is throwing error"oraoledb.oracle.1 provider not found"

provider=OraOLEDB.Oracle;Server=databaseserver;Data Source=databasename;User Id=neto;OLEDB.NET=True;ChunkSize=65535;Persist Security Info=True;

Is there any other way to create connection string for “Oracle Instant Client”?

We are able to connect to database but not from the application.

MT0
  • 143,790
  • 11
  • 59
  • 117
Var 2010
  • 1
  • The Oracle OLE DB provider is not installed, you must install it. If you don't like to install any driver, then you can use one of the pre-installed drivers from Microsoft, however they are all outdated. See https://stackoverflow.com/questions/34803106/how-to-connect-to-oracle-11-database-from-net/34805999#34805999 – Wernfried Domscheit May 19 '23 at 06:09
  • How do I install Oracle OLE DB provide? Do we have standalone installer? Doesn't want to install full version Oracle client drivers – Var 2010 May 19 '23 at 11:32
  • See [64-bit Oracle Data Access Components (ODAC) Downloads](https://www.oracle.com/database/technologies/odac-downloads.html) and/or [32-bit Oracle Data Access Components (ODAC) and NuGet Downloads](https://www.oracle.com/database/technologies/odac-nuget-downloads.html) – Wernfried Domscheit May 19 '23 at 15:11
  • I installed ODAC XCopy 32 & 64 bits but still getting "oraoledb.oracle.1 provider not found" error. I tried running in cmd (run as admin) regsvr32 oraoledb19.dll but getting "The module "%1" failed to load.\n\n Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL files.\n\n%2." Please any suggestion – Var 2010 May 22 '23 at 02:16
  • The architecture (32bit vs. 64bit) and the version of OLE DB provider must match **exactly** the version of the Instant client, see https://stackoverflow.com/questions/659341/the-provider-is-not-compatible-with-the-version-of-oracle-client#25412992 how to cleanup your Oracle client. Note, the ODAC downloads include the Oracle Instant client. – Wernfried Domscheit May 22 '23 at 06:35
  • Application is working fine with full Oracle client driver.. client wants to test using Oracle instant client. – Var 2010 May 22 '23 at 13:57
  • As said, the Oracle Instant client does not include the Oracle OLE DB provider, thus it cannot work. You would need a different provider/driver. – Wernfried Domscheit May 22 '23 at 14:14

1 Answers1

1

You can use ODBC Drivers for Oracle as an alternative solution that is compatible with major and the latest Oracle Server and Client versions, including Oracle Instant Client. It allows you to access databases using ODBC applications and to create a secure SSL connection to Oracle with an ODBC driver.

Connection String Using SSL Certificates and Keys

DRIVER={Devart ODBC Driver for Oracle};Direct=True;Host=tcps://myHost;Service Name=myServiceName;User ID=myUsername;Password=myPassword;Use SSL=True;SSL CA Cert=C:\myCaCertificate.pem;SSL Cert=C:\myClientCertificate.pem;SSL Key=C:\myPrivateClient\myKey.pem

You can check how to Connect with Oracle Using SSL

Nooruddin Lakhani
  • 7,507
  • 2
  • 19
  • 39