ODBC: New connection string parameter OnConnect
Details
| Detail name | Value |
|---|---|
| Changelog Number | 18894 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | ODBC 24.1.0 |
| Resolution Date | 2024-03-25 |
New Feature
The ODBC driver now allows the connection string parameter OnConnect. This parameter is used to run a single SQL statement immediately after the connection is established as a part of the connect process.
Example connection string
DRIVER={Exasol Driver};EXAHOST=192.168.6.11..14/<fingerprint>:8563;ONCONNECT=SELECT 1;
If the execution of the statement fails, the connection will return an error and will not be established.
Restrictions: the statement cannot contain characters that will have influence on the connection string, like “;”.
