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!