How to Connect to TopSpeed Format Data Files with Python
TopSpeed is a database engine that uses .TPS files to store data. It was developed by Clarion Software and is mainly used by older applications. TopSpeed provides an ODBC driver that enables third-party applications to connect to .TPS files, but the driver is only available for 16-bit and 32-bit Windows platforms. If you want to use Python to access TopSpeed data, you will need a solution that can bridge the architecture gap between your 64-bit Python application and the 32-bit TopSpeed ODBC driver.
One possible solution is to use the Easysoft ODBC-ODBC Bridge, which allows a 64-bit application to connect to a 32-bit ODBC driver (and vice versa). The ODBC-ODBC Bridge has two components: the Client and the Server, which can be installed on either the same machine or on different machines. The Client communicates with the Server via RPC, which means the architecture of the Client does not dictate the architecture of the Server. So, a 64-bit Client is compatible with a 32-bit Server (and vice versa).
In this article, we will show you how to use the Easysoft ODBC-ODBC Bridge to connect your Python application to TopSpeed data. We will assume that you have already installed the TopSpeed ODBC driver on a Windows machine and configured a TopSpeed ODBC data source using the 32-bit version of the ODBC Administrator. We will also assume that you have installed Python and pyodbc on another machine (which can be Windows or Linux) and that you have access to both machines over a network.
Step 1: Install the ODBC-ODBC Bridge Server
The first step is to install the ODBC-ODBC Bridge Server on the machine where the TopSpeed ODBC driver is installed. You can download the ODBC-ODBC Bridge from here. Follow the installation instructions for your platform and make sure you select the Server component when prompted.
Step 2: Install the ODBC-ODBC Bridge Client
The next step is to install the ODBC-ODBC Bridge Client on the machine where your Python application is installed. You can download the ODBC-ODBC Bridge from here. Follow the installation instructions for your platform and make sure you select the Client component when prompted.
Step 3: Configure an ODBC-ODBC Bridge Client Data Source
The final step is to configure an ODBC-ODBC Bridge Client data source on the machine where your Python application is installed. Use the 64-bit version of the ODBC Administrator to create a new data source with the following settings:
Driver: Easysoft ODBC-ODBC Bridge
Data Source Name: Any name you like, e.g. TPSBridge
Server: The IP address or hostname of the machine where the ODBC-ODBC Bridge Server is installed
User Name: A Windows user name that has access to the machine where the ODBC-ODBC Bridge Server is installed
Password: The corresponding password for the user name
TargetDSN: The name of your TopSpeed ODBC data source, e.g. TPSData
Click OK to save your data source.
Step 4: Connect to TopSpeed Data with Python
Now you are ready to connect to TopSpeed data with Python using pyodbc. Here is an example code snippet that shows how to query a .TPS file using pandas: