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.
+1
A:
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.
Hassan Syed
2009-12-10 14:37:13
so sending a date from AX4.0 to SQL Server in this format DD/MM/YYYY would still be exactly that at other end?
Tony
2009-12-10 14:40:22
yes, it should be exactly the same. I have looked at the protocol a few years ago using wireshark :D.
Hassan Syed
2009-12-10 14:44:31
A:
Look at the date formats on the 2 servers, you may have issues with localisation/regional settings
baldy
2009-12-10 14:41:57
I'm sending the date using ODBCConnection X++ class in AX Client to SQL Server, so where would I look for the setting you're talking about? Sorry I'm new to AX...
Tony
2009-12-10 14:45:56