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

KOI PAN 0 Reputation points
2023-05-18T02:23:10.8933333+00:00

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

step 2

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

empty

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

32-bit

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

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,880 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Limitless Technology 44,096 Reputation points
    2023-05-18T15:29:44.64+00:00

    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!

    0 comments No comments

  2. Tanay Prasad 2,115 Reputation points
    2023-05-19T06:58:40.1166667+00:00

    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.

    0 comments No comments

  3. Emmanuel Maenda 0 Reputation points
    2023-06-07T13:10:18.1766667+00:00

    I am also having the same issue above as KOI PAN within my Windows 10 64bit system. I checked my Registry values and they all look okay. Has anyone found any workaround with this? It doesn't look like it's a problem with Windows 7. Please help.

    0 comments No comments

  4. MBDAW 0 Reputation points
    2023-09-26T14:07:25.6266667+00:00

    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.

    0 comments No comments