I'm using ODBC Socket Server ver. 0.92 on a WIndows NT box and Tim Uckun's odbcsocketserver class (ver. .52) from a Linux box to access a MS Access database.
I'm having problems getting the queries end up with the correct format at the NT-box. (Sending INSERT statements via some webpages on the Linux box to NT).
This is an example of a SQL string:
INSERT INTO SubHistory (ID, Location, CH, SN, ExpDate, RSOCStr, Sender)
VALUES ('1','testmsg', '7','327294','08/06/2002','?Z327294 S 0 1677.9583333333
','fsas');
What happens is that the questionmark in front of 'Z327294...' vanishes. I suspected this beeing due to me not escaping the '?' but with my limited knowledge of ODBC SQL syntax I were not able to find the right way to do this. I've tried escaping with ', \, [ ] . Can anyone help me?
Thanks!
Cheers!
Aleksander Solheim
I'm having problems getting the queries end up with the correct format at the NT-box. (Sending INSERT statements via some webpages on the Linux box to NT).
This is an example of a SQL string:
INSERT INTO SubHistory (ID, Location, CH, SN, ExpDate, RSOCStr, Sender)
VALUES ('1','testmsg', '7','327294','08/06/2002','?Z327294 S 0 1677.9583333333
','fsas');
What happens is that the questionmark in front of 'Z327294...' vanishes. I suspected this beeing due to me not escaping the '?' but with my limited knowledge of ODBC SQL syntax I were not able to find the right way to do this. I've tried escaping with ', \, [ ] . Can anyone help me?
Thanks!
Cheers!
Aleksander Solheim