Daniel K

Daniel K

  • 1.9k
  • 5
  • 140

C# - ODBC connection failed

May 31 2020 11:45 AM
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!

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (3)