Important Note for 64-bit Windows Clients

Step 1: Download the “Stable Version” .pkg for Mac OS X here: http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads and run and install it (you may have to allow to ‘open anyway’ under System Preferences → Privacy) This will install the iODBC 64-bit ODBC administrator into your Applications folder. Step 2: Go to this downloads area: https://dev.mysql.com/downloads/connector/odbc/ Select macOS operating system; download the 64-bit DMG archive. Run the .pkg installer inside it . (You may have to allow it to ‘open anyway’ under System Preferences → Privacy) This will install the MySQL ODBC driver. Step 3: Run the 64-bit iODBC administrator installed in ‘Step 1’ and select the “System” tab. Select to add a new data source. NB: Select the ‘Unicode’ variant of the driver, NOT the “ANSI” one. Step 4: Give the data source a name, then set up the following parameters on it, as per: https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html server (the server hostname) (this may be an IP address, but be careful if it is a dynamic IP address, then all clients will have to be reconfigured if the IP address changes) user (a MySQL user with permission to access the MySQL database) database (name of actual physical MySQL database) port (if different to default port 3306) pwd (Optional password for username). If the iODBC administrator application crashes (some versions appear unstable), try add one parameter at a time, OK it to save, then re-open it again.) NB: The above username / password is NOT the Tlex/tlTerm/tlDatabase username/password. Press the ‘Test’ button to test – if you get a successful connection test with the “Test” button, then you’re probably ‘good to go’ in TLex/tlTerm/tlDatabase etc. Step 5: Save the information and close the iODBC administrator. Run the application (e.g. Tlex) and attempt to open it. (If it’s a new database that hasn’t been set up yet, you’ll first need to open a standalone file in TLex/tlTerm/tlDatabase and do ‘Save as: ODBC’ to set it up the first time. This is when you select the table ‘prefix’).

Important Note for 64-bit Windows Clients

[NOTE: As of April 2014, you can use the “Tools / Open Windows ODBC Configuration Dialog” menu option within the application in Windows – this is the simplest way to always open the correct ODBC administrator window, rather than doing the below.]

64-bit versions of Windows have two separate ODBC administrator panels - one for 64-bit applications, and the other for 32-bit applications. 32-bit applications (like the 32-bit versions of TLex, tlTerm and tlDatabase) can only ‘see’ 32-bit data sources, and 64-bit applications (like the 64-bit versions of TLex, tlTerm and tlDatabase) can only ‘see’ 64-bit data sources. The ODBC administrator dialog that is accessible via the Windows Control Panel on a 64-bit Windows system is for 64-bit applications (only), while the ODBC administrator dialog for 32-bit applications has