Set up ODBC connection for AGE/GIS software to write directly into database

Owned by Simon Fahrni
Last updated: Oct 17, 2023
2 min read

 Problem

Results and pressures from graphitization or measurement are not saved to the database

This may have a number of reasons. Typically only labs with an Ionplus AMS instrument will have the corresponding database available. If you do have an Ionplus AMS instrument, follow these instructions to set up database writing.

 Solution

Diagnosis - Is ODBC (32-bit) installed and set up correctly?

Make sure no samples are in the AGE system and insert a glass tube on each reactor of the AGE system.

  1. Navigate to the start menu of windows and start typing 'odbc'. If ODBC Data Sources (32-bit) appears continue with 3.

  2. If you could not find the ODBC Data Sources (32-bit) navigate toC:\Windows\SysWOW64 and execute odbcad32.exe (32 bit version). If there is no executable to be found there. You will have to install it first. Download the installer from Microsoft or contact Ionplus for help.

  3. Run the ODBC Data Sources (32-bit)

  4. Select the System DSN tab.

     

  5. Click on 'Add’ and select the MySQL ODBC 3.51 driver or alternatively the MySQL ODBC ANSI 5.3 driver. The configuration window will pop open.

  6. Enter a name that indicate the 32-bit ODBC version
    Enter the IP Address of the DB server. This will be 10.11.12.100 from within the AMS' network. For outside access (if computer in a different lab) you will have to enter the AMS systems outside IP address.
    Enter a username and password for a technical db account that has the permissions to write into the target_t table.
    Enter db_ams for database:



  7. Click on Test to check if the connection works.

  8. Save the settings with ‘OK’

  9. Now enter the Data Source Name in the AGE3/GIS software and specify table target_t: