Forum Stats

  • 3,768,556 Users
  • 2,252,810 Discussions
  • 7,874,618 Comments

Discussions

Odbc - sqora32.dll system error 1114

user492553
user492553 Member Posts: 1 Blue Ribbon
edited Feb 5, 2021 9:48AM in ODBC

Hi,

we have problems with odbc connection from windows server 2016 to oracle server 12.1.0.2.0. Odbc caller (windows machine) is running microsoft d365 Finance and Operations application.

Sometimes it works just fine but then randomly we get error Specified driver could not be loaded due to system error 1114:A dynamic link linrary (DLL) initialisation routine failed. (C:\instantclient_19_5\SQORA32.dll)

If we try to test connection from windows odbc driver configuration it is succesful. Only thing that helps, sometimes is restarting AX service.

Any idea what is happening,

Thanks in advance.

Answers

  • User_UZD8F
    User_UZD8F Member Posts: 1 Red Ribbon

    hi, I wondered if you had found any permanent resolution to this issue. We are getting exactly the same problem using instant client 1910. It has been working fine for months on one server and now intermittently comes up with that error. A server restart resolves the problem for a while. None of the other explanations I have found for this error apply because our config is correct and our connection test from the ODBC admin also works. If there was a fundamental problem with the config it would never work. We also have another server setup in exactly the same way which works perfectly and I'm not aware of any other changes that have been made on the server.

    Thanks