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.