The WorkArounds and WorkArounds2 options are documented in the Connect/Connect64 for ODBC Reference Guide.
In earlier versions, WorkArounds and WorkArounds2 were documented in the ODBCREADME.txt file.
The options are specific to each release.
Note that each of these options has potential side effects related to its use.
An option should only be used to address the specific problem for which it was designed.
To set these options on your datasource:
Add the WorkArounds or WorkArounds2 options to the ODBC data source Extended Options field. If adding multiple options, separate them by a semicolon.
If the driver does not have an Extended Options field, add the WorkArounds or WorkArounds2 options to the registry.
- Launch regedit and open the data source section you want to modify
For 32-bit system ODBC data sources on 32-bit Windows; for 64-bit system ODBC data sources on 64-bit Windows:
For 32-bit system ODBC data sources on 64-bit Windows:
For 32-bit/64-bit user ODBC data sources on 32-bit/64-bit Windows
- Add the string value pair WorkArounds (or WorkArounds2) with a value of n where the value n is the cumulative value of all options added together.
e.g., WorkArounds 540016640 is a combination of WorkArounds 536870912 + WorkArounds = 2097152 + WorkArounds = 1048576.
WorkArounds=536870912. This option allows for re-binding parameters after calling SQLExecute for prepared statements.
WorkArounds=2097152. Some applications incorrectly specify a precision of -1 for character types. This option overrides the specified
precision and sets the precision to 2000.
WorkArounds=1048576. Some applications incorrectly specify a precision of 0 for character types when the value will be SQL_NULL_DATA. This
option overrides the specified precision and sets the precision to 256.
NOTE: when using the Shadow 7 ODBC driver: add WA / WA2 instead of WorkArounds / WorkArounds2 !
When using a connection string, you can add these options to your connectionstring:
When running on UNIX / Linux, edit the file to which your ODBCINI environment variable is pointing to (odbc.ini). To the ODBC data source section, add each option on a separate line.