A
Andy Sjostrom
Hi!
I am connecting to a SQL Server 2000 using an OleDbConnection. I would like
to be able to configure the OleDbConnection so that all SQL statements
passed through it uses QUOTED_IDENTIFIER OFF. SQL Server Books Online says
(SET QUOTED_IDENTIFIER):
"The SQL Server ODBC driver and Microsoft OLE DB Provider for SQL Server
automatically set QUOTED_IDENTIFIER to ON when connecting. This can be
configured in ODBC data sources, in ODBC connection attributes, or OLE DB
connection properties. SET QUOTED_IDENTIFIER defaults to OFF for connections
from DB-Library applications."
How do I do that programmatically without passing "SET QUOTED IDENTIFER OFF"
in the first SQL statement?
Thanks!
Andy Sjostrom
MS MVP - Mobile Devices
I am connecting to a SQL Server 2000 using an OleDbConnection. I would like
to be able to configure the OleDbConnection so that all SQL statements
passed through it uses QUOTED_IDENTIFIER OFF. SQL Server Books Online says
(SET QUOTED_IDENTIFIER):
"The SQL Server ODBC driver and Microsoft OLE DB Provider for SQL Server
automatically set QUOTED_IDENTIFIER to ON when connecting. This can be
configured in ODBC data sources, in ODBC connection attributes, or OLE DB
connection properties. SET QUOTED_IDENTIFIER defaults to OFF for connections
from DB-Library applications."
How do I do that programmatically without passing "SET QUOTED IDENTIFER OFF"
in the first SQL statement?
Thanks!
Andy Sjostrom
MS MVP - Mobile Devices