OleDbConnection and SET QUOTED_IDENTIFIER OFF

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLEDBConnection Properties 1
Connection string - Query SQL Server with ADO 1
ConnectionString: set ANSI NULL on/off 0
DAO IS DED 16
Creating a connection to MSSQL 2000 on MS Server 2003 2
"IF" test in SP evals to True and False at same time using DataAdapter.FillSchema() 7
Updating SQL Server Linked Server 3
errors while connecting to Sql server with DSN connect 1

Top