Hello,
I am attempting to write a Lazarus program using a TMSSQLConnection on Linux (Ubuntu 16.04 64 bit) with FreeTDS. Whenever I try to apply updates on my TSQLQuery component and commit the transaction on its associated TSQLtransaction component I receive this error:An error occurred while applying the updates in a record: Connection : Error 2403 : Attempt to initiate a new Adaptive Server operation with results pending Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?') Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?') Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?') Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?') . Press OK to ignore and risk data corruption. Press Abort to kill the programIf I press OK the updates are not actually applied. It looks like no matter what I do I cannot edit field values and have them applied to the SQL server database.I have tried changing the freetds.conf file to include the following: [global] client charset = UTF-8
probably try add also: dump file = freetds.log then you can look into log file what and when actually happens ...
I have even tried setting the charset property on the TMSSQLConnection to UTF-8.
Yes it is needed What verision of FPC/Lazarus do you use? Do you have DefaultSystemCodePage = UTF8 ? Can you try with TRUNK or 3.2 branch? What is version of remote SQL Server ? -Laco.
-- _______________________________________________ lazarus mailing list [email protected] https://lists.lazarus-ide.org/listinfo/lazarus
