I have connected to a database using a ConnectingString. One of it's options is the Provider. If I use the default provider (MSDASQL, using ODBC) I can't get OEM characters get translated to ANSI characters, but I can get error messages. If I use the SQL Provider (SQLOLEDB) I get the translation done, but if there is an error the only description I get is Automation Error.

I can get the Error Number that equals to those in ODBC, but can I get the descriptions using the SQL provider???...Or can I do the translation between OEM and ANSI without a DSN???

Thanks in advance