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