Creating an ODBC connection for tsPortal
Applies to: tsPortal
tsPortal communicates with the MySQL server via two ODBC connections ("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 but is more easily accessible from the Timestone Software website with the link below. The driver must be installed and configured on each and every computer wishing to use tsPortal..
An ODBC connection must be established on every computer wishing to run tsPortal
Downloading and installing the ODBC connector
Download the ODBC driver from the licensed downloads page of the Timestone Website. A direct download is available here
Once downloaded run the installer on any computer wishing to use tsPortal.
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
Launch the Windows ODBC Data Sources (64bit) utility.
Figure 1: The ODBC configuration window
Configuring the connection
Two connections are made using the following steps:
Create the first connection - tsportal
- Select the System DSN tab. This will make the connection available to all users on this computer.
- Click Add - a list of all installed drivers is presented. Scroll down the list and select MySQL ODBC Unicode
- Create a connection as per the parameters in Figure 2. Make sure to substitute the IP address displayed in the screen grab to that of your MySQL server.
- The user and password are both tsPortal.
- Leave the Database window blank
- Click OK to save the connection parameters
Figure 2: The tsportal connection
Create the second connection - tsportal2
- Select the System DSN tab. This will make the connection available to all users on this computer
- Click Add. A list of all installed drivers is presented. Scroll down the list and select MySQL ODBC Unicode
- Create a connection as per the tsportal connection named tsportal2
- The user and password are both tsPortal
- In the Database window using the drop down to select the tsportal database
- Click OK to save the connection parameters
Figure 3: The tsportal2 connection
End of article