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.
Asked
Active
Viewed 721 times
0
-
You should accept and mark up answers that solve your problem. – Hassan Syed Dec 16 '09 at 15:23
2 Answers
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.
Hassan Syed
- 20,075
- 11
- 87
- 171
-
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 The Lion Dec 10 '09 at 14:40
-
1yes, it should be exactly the same. I have looked at the protocol a few years ago using wireshark :D. – Hassan Syed Dec 10 '09 at 14:44
0
Look at the date formats on the 2 servers, you may have issues with localisation/regional settings
baldy
- 5,524
- 4
- 22
- 19
-
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 The Lion Dec 10 '09 at 14:45