Error: Data source name not found and no driver specified or ODBC MSAccess Driver Login Failed or Unable to Load odbcji

[jovivier]

If you receive an error message
"Data source name not found and no default driver specified"
or
"ODBC MSAccess Driver Login Failed "
or
"Unable to Load odbcji32.DLL"

IRRICAD Link uses a 64-bit MS Access driver and there is a known issue with this driver and Office 2010. Microsoft Updates may ‘break’ the driver. Each time this happens the way to fix it is to run a bat file located in the Irricad Link \DBSupport folder.

In Windows 7 you can right-click on the FixAccessDatabaseEngine.bat file and select “Run as Administrator”. In Windows 10 and Version 19 or greater you can right-click on the FixAccessDatabaseEngine.bat file and select “Run as Administrator”.

For Windows 10 and older versions (v18 and older) you will actually have to run it inside a command prompt that has been run as Administrator:-
1. Browse to C:\Windows\SysWow64 and right-click on CMD.exe and select “Run as Administrator”. (Or in the Search field type CMD and then right-click on the CMD.exe and select “Run as Administrator”).

2. Change the folder to the DBSupport folder in the installed IRRICAD Link folder, e.g. C:\Program Files\Irricad\Irricad Link Bricscad\DBSupport or C:\Program Files\Irricad\Irricad Link Autocad\DBSupport.
In the command prompt type in cd C:\ <enter>
cd program files<enter>
cd irricad<enter>
cd Irricad Link Bricscad<enter> or cd Irricad Link Autocad<enter>
cd DBSupport<enter>

3. Then type FixAccessDatabaseEngine and press enter.
Hopefully you should see a “this was run successfully…” message.

Unfortunately, future Microsoft Updates will probably ‘break’ it again. The long term solution is to upgrade from Office 2010.

This has also recently been seen with Office 365 and the previous Microsoft Office update (Sept 2020). According to Microsoft this has now been addressed (October 2020) and the fix should be available in the next update. Alternatively, you can do a manual update from this link https://support.microsoft.com/en-us/off ... de917611c5 .

Note that this issue has been resolved in IRRICAD Link V19, where we have programmed a work-around that should not be affected by any Microsoft updates or programs causing Office to reconfigure. However, if you do need to the run the "FixAccessDatabaseEngine" you can now simply double-click on the bat file rather than using an 'elevated' command prompt as detailed above.

[jovivier]

If successfully running the FixAccessDatabaseEngine.bat does not solve the problem then the issue may be in the registry.
IRRICAD has its own "ODBC" registry key which is removed when IRRICAD Link is uninstalled. Therefore, if you install the new version side-by-side and at a later date uninstall the previous version then the IRRICAD ODBC registry key will be removed and IRRICAD Link will not able to access the database items.

To fix, other than reinstalling the latest version, download the required registry key and import into your registry:-
1. Download the registry key from https://www.irricad.com/irricad/downloa ... cadreg.zip and save to your hard-drive.
2. Browse to the saved zip file and double-click on it to open.
3. Drag the reg file out of the zip to a known place.
4. Run Regedit.
5. In the registry editor, select File|Import and browse for the ODBCIrricadreg.reg file. Select the file and click [Open]. The IRRICAD registry key will now be added to your registry.

Note that this registry key assumes that the Office14 files are located at C:\Program Files\Common Files\microsoft shared\OFFICE14.
If you need to change the path the registry key is located at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Irricad Access Driver (*.mdb, *.accdb).

The IRRICAD Team