Adding a Database Source on a 64-bit System

Answered

Follow

Jason

• June 15, 2022 22:47
• Edited

A user asked us the following question:

I attempted to add a database source using the ODBC Data Source Administrator tool on a 64-bit system, but I was presented with the following error: 

How can I resolve this?

1

• 

  Jason

  • September 24, 2020 22:35
  • Edited

  The ODBC Data Source Administrator Tool accessed from the Control Panel points to the 64-bit versions of system files. However because GoldSim is a 32-bit application on a 64-bit system, the 32-bit version of the ODBC Administrator Tools must be used in order to add database source.

  Follow these steps to configure your 64-bit system to link GoldSim to a database using a 32-bit ODBC driver for MS Access 2010:

  1. Download and install the AccessDatabaseEngine.exe from Microsoft: https://www.microsoft.com/en-us/download/details.aspx?id=13255
  2. Select the 32-bit version of the AccessDatabaseEngine.exe
  3. Run the AccessDatabaseEngine.exe installer and follow the defaults.
  4. After installation, start up the 32-bit ODBC Administrator
  5. When the application starts, you should see a reference to the MS Access Database with the *.accdb file type.
  6. Test the database connection using the example GoldSim model by following the next steps.
  7. Add a new data source by re-starting the ODBC administrator (if you already closed it). Within the User DSN tab, click the Add button.
  8. Scroll down to find the MS Access (*.accdb) database driver.
  9. Give it the name "Generic Database" then click the Select button
  10. Browse to the location of the example database that comes with GoldSim called "GenericDatabase.accdb" then click OK.
  11. You should now see the data source configured as shown below.
  12. Click OK to accept this data source then click OK again to close the ODBC Administrator.
  13. Start GoldSim and from the File menu, select "Open Example..."
  14. Browse to the GenericDatabase.gsm example file.
  15. Open the properties of the Constant_Generic_Scalar element.
  16. Click on the Database tab and you will see the following message:
  17. Select the "Generic Database" source that you created earlier.
  18. Click the Define Fields button and add the "Value" field then click the "Download Now button.
  19. You should see the Status update at the bottom of this dialog, showing you that the download succeeded at the current date and time.

  0

  Comment actions Permalink
• 

  Jason

  • September 24, 2020 22:33

  Note:

  If you see the following error message, it means you accidentally installed the wrong driver (AccessDatabaseEngine_X64.exe).

  

  Follow these instructions to fix it:

  1. Start the Windows Control Panel and go to "uninstall a program"
  2. Select the Microsoft Access database engine 2010 (English), and click "Uninstall"
  3. After the uninstall is complete, run the AccessDatabaseEngine.exe installer
  4. After successful installation, you should see the following message:
  5. Test the ODBC data source by following the steps in the above comment, starting with Step #7.

  0

  Comment actions Permalink

Please sign in to leave a comment.