Creating an ODBC connection for tsPortal

Applies to: tsPortal


tsPortal communicates with the MySQL server via an ODBC connection (Open Database Connectivity). General information on ODBC is available "here"

The ODBC driver (also called ODBC connector) for MySQL is available for download from the MySQL website. The driver must be installed and configured on each and every computer wishing to use tsPortal. The configuration varies slightly between 32bit and 64bit computers and each is explained below.

An ODBC connection must be established on every computer wishing to run tsPortal

Downloading and installing the ODBC connector

The connector may currently be downloaded from the following link. Please note this link may change in time. If the link is broken visit mysql.com and follow the links to the ODBC connector download.

"Download the 32bit connector"


"Download the 64bit connector"

Once downloaded run the installer on any computer wishing to use tsPortal. Be sure to run the installer appropriate to your computer although there is no harm in installing both the 32bit and the 64bit drivers

Launching the driver connection utility

Once the driver is installed the connection must be configured using the ODBC Data Source Administrator utility. The following assumes the host computer is 64bit and FIlemaker Pro is also 64bit.

On 64bit machines

Search for an run the Windows 64bit ODBC Data Sources utility.


Figure 1: The ODBC configuration window

Configuring the connection

Four connections are made using the following steps:

Create the first connection - timestone.

  1. Select the System DSN tab. This will make the connection available to all users on this computer
  2. Click Add. A list of all installed drivers is prsented. Scroll down the list and select MySQL ODBC (use Unicode)
  3. Create a connection as per the parameters in Figure 2. Make sure to substitute the IP address to your MySQL server for the one shown in the screen grab. The user and password are both tsPortal.
  4. Click OK to save the connection parameters


Figure 2: The timestone connection

Create the second connection - timestone_fp.

  1. Select the System DSN tab. This will make the connection available to all users on this computer
  2. Click Add. A list of all installed drivers is prsented. Scroll down the list and select MySQL ODBC (either ANSI or Unicode)
  3. Create a connection as per the timestone connection but select the timestone_fp database instead. The user and password are both tsPortal.
  4. Click OK to save the connection parameters

Create the third connection - timestone_fpx.

  1. Select the System DSN tab. This will make the connection available to all users on this computer
  2. Click Add. A list of all installed drivers is prsented. Scroll down the list and select MySQL ODBC (either ANSI or Unicode)
  3. Create a connection as per the timestone connection but select the timestone_fpx database instead. The user and password are both tsPortal.
  4. Click OK to save the connection parameters

Create the fourth connection - timestone_aux.

  1. Select the System DSN tab. This will make the connection available to all users on this computer
  2. Click Add. A list of all installed drivers is prsented. Scroll down the list and select MySQL ODBC (either ANSI or Unicode)
  3. Create a connection as per the timestone connection but select the timestone_aux database instead. The user and password are both tsPortal.
  4. Click OK to save the connection parameters

Once complete their should be four connections - timestone, timestone_fp, timestone_fpx, timestone_aux

32bit machines

If your computer is 32bit or you are running the 32bit version of Filemaker Pro, you will need to downoad the 32bit connector/driver then use the 32bit ODBC configuration utility. The connections themselves are as described above.

End of article