Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting ANSI_WARNINGS off in OLEDB connection string
Message
De
26/09/2003 13:17:14
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Setting ANSI_WARNINGS off in OLEDB connection string
Divers
Thread ID:
00832769
Message ID:
00832769
Vues:
258
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform