1

I have an problem with an ODBC connection and C# scripting, when opening an ODBC connection.

The error message is: Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in instantclient_12_32bit, C:\Oracle\instantclient_12_32bit\SQORA32.DLL) driver could not be found.

The ORACLE_HOME and Path environment variables are set with correct path "C:\Oracle\instantclient_12_32bit".

Has anyone an idea, what's the problem? The dll is in the directory as named.

Thanks in advance!

lerx
  • 11
  • 3
  • Did you compile your application as 32-bit or 64-bit (or "AnyCPU")? – Wernfried Domscheit May 31 '20 at 12:36
  • What is your connectionString? – Wernfried Domscheit May 31 '20 at 12:36
  • hey, thanks for your fast reply! the driver is configured with the following attributes: dsn = "meddb", tns service name = "ek_nt_ed", userid = "dp" The test for the connection works also. the connection string I am using is the following: connstring = "dsn=meddb;server=ek_nt_ed;uid=dp;pwd=XXX;" Am I doing anything wrong? – lerx May 31 '20 at 14:50
  • maybe also interesting: its configured as system dsn. – lerx May 31 '20 at 15:38
  • Your connectionString does not specify any driver, it should not work. – Wernfried Domscheit Jun 01 '20 at 05:23
  • if I am using an connection string like: connstring = "driver={Oracle in instantclient_12_32bit};dsn=meddb;server=ek_nt_ed;uid=dp;pwd=XXX;" with Oracle in instantclient_12_32bit as driver name (from system driver), I am getting the same error message.. any other idea? :) Thanks! – lerx Jun 01 '20 at 09:10
  • You did not answer my first question yet. – Wernfried Domscheit Jun 01 '20 at 11:25
  • Sorry, the application is compiled as 32bit. – lerx Jun 01 '20 at 15:03
  • Then it should work actually. Did you install more then one Oracle Client? Perhaps you messed them up. How do you try to connect, please show us your code. Maybe have a look at https://stackoverflow.com/questions/34803106/how-to-connect-to-oracle-11-database-from-net/34805999#34805999 – Wernfried Domscheit Jun 01 '20 at 15:26

0 Answers0