>I succeeded to bypass that issue by adding this in the oCommand.CommandText in my SQLUpdate() and SQLInsert() methods:
>
>

>                ' In SQL Server, we have to turn off ANSI Warnings as we will have an error
>                ' if a field value is greater than the field length
>                If nBackend = 2 Then
>                    oCommand.CommandText = "SET ANSI_WARNINGS OFF; " + oCommand.CommandText
>                End If
>

>
>However, this is effective for all updates or inserts in a hit. If anyone would have a simpler method where the setting would only be set once per hit, that would be great.

Hi Michel,

I was reading on these settings yesterday in the SQL Server book I have and it is said that the connection setting overwrites database setting. Perhaps you can set it per connection?

UPDATE. I tried to search on google how to set it per connection, but nothing good comes up so far :(