>>From BOL:
>>"The SQL Native Client ODBC driver and SQL Native Client OLE DB Provider for SQL Server automatically set ANSI_WARNINGS to ON when connecting. This can be configured in ODBC data sources, in ODBC connection attributes, or OLE DB connection properties set in the application before connecting."
>>
>>Can you configure connection properties?
>
>This is what I am trying to figure out. I have been trying to find where exactly I need to apply that setting.
Not sure if that helps, but check
http://msdn2.microsoft.com/en-us/library/ms131709.aspxSQLSetConnectAttr()
O!
I found this also:
http://msdn2.microsoft.com/en-us/library/ms130822.aspx
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.