Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting ANSI_WARNINGS off in OLEDB connection string
Message
From
26/09/2003 13:17:14
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Setting ANSI_WARNINGS off in OLEDB connection string
Miscellaneous
Thread ID:
00832769
Message ID:
00832769
Views:
257
Is there a parameter I can include in an OLEDB connection string to the following set commands OFF, so I can avoid setting them off in the stored proc(s) that need them off?

ANSI_WARNINGS
ANSI_NULLS
CONCAT_NULL_YIELDS_NULL


I've already tried
AnsiNPW=no        -- works in ODBC
Ansi warnings=off -- puts into Extended properties attribute and adds  
                     several other parameters as well, but no effect
Well, I say no effect - in SQL Profile, the Audit Login for connections show that warnings are on, and there is no batch after (like from a VFP SPT connection) that then sets them off, nor does it show if this is an existing connection.

TIA
Insanity: Doing the same thing over and over and expecting different results.
Next
Reply
Map
View

Click here to load this message in the networking platform