Disable ODBC default settings
-
Quoting from MSDN: "SQL Query Analyzer uses the SQL Server ODBC driver, which, by default, sets these SQL-92 options on: SET ANSI_WARNINGS, SET ANSI_PADDING, and SET ANSI_NULLS. Any errors returned are formatted as ODBC errors rather than DB-Library errors." Is there any way to modify these options so that they are not the default? Thanks!
-
Quoting from MSDN: "SQL Query Analyzer uses the SQL Server ODBC driver, which, by default, sets these SQL-92 options on: SET ANSI_WARNINGS, SET ANSI_PADDING, and SET ANSI_NULLS. Any errors returned are formatted as ODBC errors rather than DB-Library errors." Is there any way to modify these options so that they are not the default? Thanks!
If you mean in Query Analyzer, go to Tools/Options and change the settings on the Connection Properties tab. This affects new connections. Stability. What an interesting concept. -- Chris Maunder