Error: Data source name not found and no driver specified

FAQs and Tips specific to IRRICAD Link
Post Reply
User avatar
jovivier
Site Admin
Posts: 524
Joined: Thu Mar 12, 2009 2:57 pm
Company: LVL
City / Town: Blenheim
Location: Lincoln, New Zealand
Contact:

Error: Data source name not found and no driver specified

Post by jovivier » Thu Mar 01, 2018 12:35 pm

If you receive an error message "Data source name not found and no default driver specified":

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 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).

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

Post Reply