Unable to load odbcji32.dll - UniDac with Access Provider

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
johnbitner
Posts: 22
Joined: Thu 10 Sep 2009 16:18
Location: United States

Unable to load odbcji32.dll - UniDac with Access Provider

Post by johnbitner » Mon 21 Dec 2015 13:13

I have several commercial applications that as of last week stopped opening and return the error message "Unable to load odbcji32.dll" when launching. Several have not been updated in many months so our code has not changed. We are using UniDAC 6. In several apps specifically 6.2.8 and 6.2.9. We are seeing this error on Windows 10 and also on Windows 7 and 8 when Office 2016/365 is installed and updated. This seems to me to be related to the Windows 10 November update and/or the recent Office 2016/365 updates. Right now I cannot find a work around.

Has anyone else seem this error and have any suggestions?

johnbitner
Posts: 22
Joined: Thu 10 Sep 2009 16:18
Location: United States

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by johnbitner » Tue 22 Dec 2015 14:09

The first error message is:
Title: "ODBC driver for Microsoft Access installation problem"
Message: "Unable to load odbcji32.dll"

The second error message is:
"[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed."

The third error message is:
"The operating system is not presently configured to run this application."

Any ideas?

johnbitner
Posts: 22
Joined: Thu 10 Sep 2009 16:18
Location: United States

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by johnbitner » Tue 22 Dec 2015 16:34

Found the problem. Hope this helps someone else with the same errors.

It looks like an Office 2016/Office 365 update changes the path for the Access ODBC Driver.

In the registry browse to:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb, *.accdb)

The driver and setup values are:
C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\Office16\ACEODBC.DLL

The values should be:
Driver: %WINDIR%\system32\odbcjt32.dll
Setup: %WINDIR%\system32\odbcjt32.dll

Once this change is applied the errors go away.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by AlexP » Wed 23 Dec 2015 13:10

hello,

We installed both Windows 10 and Office 2016. Nothing changed in the registry, and UniDAC still works with both new and old databases correctly. Please clarify, after which product installation did this record appear in the registry?

esbglenn
Posts: 1
Joined: Fri 08 Feb 2013 11:15

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by esbglenn » Mon 04 Jan 2016 07:16

I discovered this problem with odbcji32.dll on our Windows 10 workstations today...

Doing a bit of searching there were quite a few reports that a recent Windows 10 update messed up several system files. The recommendation given was to install the Access Database Engine. I did this and our problems were fixed :)

So not a UniDAC problem - but nice to know a fix - here is the helpful article:

http://www.lucion.com/kb-database-connection-error.html

alexbozhko
Posts: 1
Joined: Wed 20 Jan 2016 15:43

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by alexbozhko » Wed 20 Jan 2016 16:28

I have same problem with Windows 8.1 and Office 365. Unfortunately, the solution didn't help me. Connection start working correctly, when I uninstalled Office.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by AlexP » Thu 21 Jan 2016 11:50

As I wrote earlier, we couldn't reproduce the issue. Try the above solutions.

Weaker
Posts: 1
Joined: Thu 28 Jul 2016 15:42

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by Weaker » Fri 29 Jul 2016 07:36

alexbozhko wrote:I have same problem with Windows 8.1 and Office 365. Unfortunately, the solution didn't help me. Connection start working correctly, when I used Phen375 pills on https://skinnyexpress.com/phen375-review-and-results I uninstalled Office.
I had the same problem on Windows 8 recently and I upgraded to Windows 10 finally and that fixed it and it's working fine now.
Last edited by Weaker on Sat 21 Jan 2017 15:30, edited 3 times in total.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by AlexP » Mon 01 Aug 2016 08:03

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

ian231
Posts: 1
Joined: Thu 02 Nov 2017 09:26

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by ian231 » Thu 02 Nov 2017 09:28

alexbozhko wrote:I have same problem with Windows 8.1 and Office 365. Unfortunately, the solution didn't help me. Connection start working correctly, when I uninstalled Office.
I discovered this problem with odbcji32.dll on our Windows 10 workstations today...

Doing a bit of searching there were quite a few reports that a recent Windows 10 update messed up several system files. The recommendation given was to install the Access Database Engine. I did this and our problems were fixed :)

So not a UniDAC problem - but nice to know a fix- here is the helpful article:

http://www.lucion.com/kb-database-connection-error.html

MaximG
Devart Team
Posts: 1164
Joined: Mon 06 Jul 2015 11:34

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by MaximG » Mon 06 Nov 2017 08:32

We are glad that the issue was rectified. We will add the description of the issue solution to our Knowledge Base.

edwards142
Posts: 2
Joined: Thu 26 Apr 2018 06:22

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by edwards142 » Thu 26 Apr 2018 06:39

johnbitner wrote:
Tue 22 Dec 2015 14:09
The first error message is:
Title: "ODBC driver for Microsoft Access installation problem"
Message: "Unable to load odbcji32.dll"

The second error message is:
"[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed."

The third error message is:
"The operating system is not presently configured to run this application."

Any ideas?


I want to help you out buddy as I too frequently render these kinds of situations in my Access Database. Recently I and my friend got stuck in this type of ODBC error:

Access 1919 – configuring ODBC data source Error
Access Run-time 3146 ODBC Call Failed Error

We both have fixed this error manually and by own. if you want to check the manual steps then you can may be it work for your problem also.

MaximG
Devart Team
Posts: 1164
Joined: Mon 06 Jul 2015 11:34

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by MaximG » Thu 26 Apr 2018 13:47

Thank you for the provided information. Perhaps it will be useful if our users have similar problems

WalterOney
Posts: 1
Joined: Thu 14 Jun 2018 05:32

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by WalterOney » Thu 14 Jun 2018 05:43

johnbitner wrote:
Mon 21 Dec 2015 13:13
I have several commercial applications that as of last week stopped opening and return the error message "Unable to load odbcji32.dll" when launching. Several have not been updated in many months so our code has not changed. We are using UniDAC 6. In several apps specifically 6.2.8 and 6.2.9. Phenq reviews and results are amazing for weight loss We are seeing this error on Windows 10 and also on Windows 7 and 8 when Office 2016/365 is installed and updated. This seems to me to be related to the Windows 10 November update and/or the recent Office 2016/365 updates. Right now I cannot find a work around.

Has anyone else seem this error and have any suggestions?
I faced the same problem once. I kept un-installing and re-installing my applications one by one and as far as I remember, after un-installing and re-installing Microsoft Office 365, the problem disappeared. So I would suggest you to uninstall MS Office once and check.

johnyjackson
Posts: 1
Joined: Mon 09 Jul 2018 12:42

Re: Unable to load odbcji32.dll - UniDac with Access Provider

Post by johnyjackson » Mon 09 Jul 2018 12:51

WalterOney wrote:
Thu 14 Jun 2018 05:43
johnbitner wrote:
Mon 21 Dec 2015 13:13
I have several commercial applications Anavar-Results that as of last week stopped opening and return the error message "Unable to load odbcji32.dll" when launching. Several have not been updated in many months so our code has not changed. We are using UniDAC 6. In several apps specifically 6.2.8 and 6.2.9. reviews and results are amazing for weight loss We are seeing this error on Windows 10 and also on Windows 7 and 8 when Office 2016/365 is installed and updated. This seems to me to be related to the Windows 10 November update and/or the recent Office 2016/365 updates. Right now I cannot find a work around.

Has anyone else seem this error and have any suggestions?
I faced the same problem once. I kept un-installing and re-installing my applications one by one and as far as I remember, after un-installing and re-installing Microsoft Office 365, the problem disappeared. So I would suggest you to uninstall MS Office once and check. HGH-GNC
Hi WalterOney I follow all the steps as you discussed above. I uninstall MS Office but facing the same problem, there is no change. Please provide if there any alternate method to solve?

Post Reply