ODBC data transfer to SQL server

Question

How does the ODBC driver transfer data between an application to MSSQL Server 2005?

Is it serialized?

I'm trying to send data between SQL Server 2005 & MS Dynamics 4.0 but I suspect my data is altered by the ODBC driver in between.

Answer 1

Its sent as a wide-character string to SQL server -- i.e., a SQL query batch. No transformation needs to take place. The return data is structured in a protocol called TDS.

I believe if you are using the ASCII functions of the ODBC native client it gets upscalled to wide-character.

Answer 2

Look at the date formats on the 2 servers, you may have issues with localisation/regional settings