>>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.

Maybe you should ask this question on .NET forum ?