Before using GoldSim's database features you must first identify the databases you need to access using the Windows ODBC Data Sources (32bit) option. This allows you to define a name for each data source, and associate the data source with a specific database file. This article described how to connect to a Microsoft Access database.
To add a data source to your computer, do the following (the instructions here are for Windows 10; they may differ slightly for other Windows versions):
- Click the Windows icon along your taskbar.
- Type ODBC and select ODBC Data Sources (32-bit).
Notes: There will also be an option for 64-bit. It is important that you select 32-bit option
- You can define your database(s) as either ‘User DSN’ or ‘System DSN’, depending whether you want it to be private or public, respectively. Add a data source by pressing the Add... button.
- Select a driver with the same file extension as your database and press Finish. Note, the selected driver in this example is for Microsoft Access.
- Click Select... within database section and locate your database file.
- Locate and select the specific database file you wish to connect. Click Ok.
- Enter Data Source Name as the same name as your database file. Click Ok.
- Open GoldSim example file: GenericDatabase.gsm.
- Open the Database tab of the data element called Constant_Generic_Scalar.
- Select Database pulldown and select the database file we created called GenericDatabase.
- Click Download Now.
- The Status is now listed as Download succeeded at date and time. And the data is loaded into the element.