Daniel K

Daniel K

  • NA
  • 16
  • 2k

C# - ODBC connection failed

May 31 2020 11:45 AM
Hello,
 
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". But the dll is in the directory as named.
 
Futher Information: 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? Thanks in advance!

Answers (3)