Install and configure PI SQL Client ODBC
- Last UpdatedJan 04, 2023
- 1 minute read
- PI System
- PI SQL Client ODBC 2021
- Developer
For complete instructions about the PI SQL Client ODBC installation, see the PI SQL Client ODBC Administrator Guide.
-
Install the PI SQL Client ODBC driver on the machine where DG4ODBC for Windows is installed.
-
In the Windows ODBC Administrator, add a System ODBC data source (DSN) that connects to the target database.
On 64-bit Windows systems, both 32-bit and 64-bit versions of ODBC Administrator are available. Make sure you use the platform that corresponds to the DG4ODBC platform.
-
On the Workarounds tab, select Variant as String and set Maximum String Size to 1333.
-
On the Connections tab, click Test Connection to test the connection to the data source.