Failed to add 64-bit system DSN in ODBC Data Source Administrator tool

Question

I'm trying to add a 64-bit system DSN (Microsoft Access Driver) in ODBC Data Source (64-bit). Steps as follows.

After these steps, the system DSN list is still empty.

However, I successfully added a 32-bit system DSN in ODBC Data Source (32-bit).

Is there any possible reason that may leads to the failure in adding 64-bit system DSNs?

Answer 1

I installed the version linked below. I’m able to create a system DSN for an ACCDB file, but Access itself stops working. It seems this version may not be the latest, yet the latest version doesn’t display the 64‑bit system DSN option for ACCDB files.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Has anyone reported this issue to the Microsoft support team?

Answer 2

This worked for me. I was trying to add a database to install Orcad X, and it was always blank.

I had to reinstall the ODBC x64 driver in win11, and then the 'new' Access database driver showed up in the list

installed from here

Answer 3

I was having the same problem - going through the steps to create a 64-bit system DSN (using ODBC Administrator 64 bits) and at the end, the DSN would not be listed in the System DSN tab.

I had ACEODBC.DLL version 16.0.16626.20086 (found in C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16) listed as the driver for 64 bits.

Downloading AccessDatabaseEngine_X64.exe from https://www.microsoft.com/en-US/download/details.aspx?id=13255 and installing it on my Windows 11 solved the problem.

I now have ACEODBC.DLL version 14.00.7010.1000 (installed to C:\Program Files\Common Files\microsoft shared\OFFICE14) and am now able to successfully create a MS Access 64-bit System DSN. I hope this helps others.

Answer 4

Hi,

Here are a few troubleshooting steps you can try:

1. Right-click on the "ODBC Data Source Administrator (64-bit)" application and select "Run as administrator" to ensure you have the necessary permissions to make changes.
2. Make sure you have the appropriate driver installed for the version of Microsoft Access you are using. You can verify this by checking the "Drivers" tab in the ODBC Data Source Administrator and ensuring that the Microsoft Access Driver is listed.
3. The 32-bit version of ODBC Administrator will not allow you to create 64-bit system DSNs. So ensure that you are using the 64-bit version of the ODBC Data Source Administrator corresponding to your system architecture.
4. Open the Registry Editor (regedit), go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers, and ensure that there is an entry named "Microsoft Access Driver" with the correct version information.
5. Try repairing or reinstalling Microsoft Access to ensure that all necessary components are properly installed.

Best Regards.

Answer 5

Hello,

If you're having trouble adding a 64-bit system DSN with the ODBC Data Source Administrator tool, here are some solutions you can try:

• Run the tool as an administrator: Right-click on the shortcut or executable and select "Run as administrator" to make sure you have the necessary permissions.
• Check compatibility mode: Make sure the tool isn't running in any compatibility mode by going to "Properties" and unchecking any options. This can help with 64-bit system DSN creation.
• Verify driver compatibility: Check that the ODBC driver you're using is compatible with your operating system and architecture. You can find this info in the driver's documentation or by contacting the provider.
• Use the correct version of the tool: You need the 64-bit version of the ODBC Data Source Administrator tool to create 64-bit system DSNs.
• Check registry settings: Open the Registry Editor and navigate to the appropriate key for your system. Make sure the entries for the driver you want to use are present and configured correctly.

For 64-bit systems:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

For 32-bit systems:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources

Hope this helps!