Connecting using Driver Compatibility option via ODBC

Abstract: Connecting using Driver Compatibility option via ODBC

Problem: Customers would like the InterSolv ODBC driver to prompt for information the same as the way the Visigenic driver did. How can this be done. Solution: Starting with version 3.10 of the InterSolv ODBC driver, one can add a registry entry "DriverCompatibility" to the data source to have this behavior. Set the value of this entry to "1". One other workaround is to supply the dsn, uid and pwd to the connection string and also set the Driver Completion to "SQL_Driver_NOPROMPT" for SQLDriverConnect without adding the compatibility switch to the registry.