CODEWITHSUNDEEP
odbc-sql-server-driver
Tony The Lion
Tony The Lion

Reputation: 63190

ODBC data transfer to SQL server

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.

Upvotes: 0

Views: 851

Answers (2)

Hassan Syed
Hassan Syed

Reputation: 20485

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.

Upvotes: 1

baldy
baldy

Reputation: 5541

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

Upvotes: 0

Related Questions