Work with MSSQL, ADO and ZEOSLIB with Lazarus
lazarus / 16-Databases

----------------------------------------------------------------------
HappyHippo · 2018-09-07 09:51

Hello, i tried to use the ZEOSLIB with ADO to work with Data on MSSQL-
Server. If i connect to a table, which contains just fields with
strings, it works fine, but if i try it with other fieldtypes (i.e.
DateTime) i get after compiling of the progran strange error messages
like "Invalid variant typecast". Have someone any expiriance with that
kind of problems?

Regards

----------------------------------------------------------------------
af0815 · 2018-09-07 11:38

The First question are
What for a version of zeoslib ?
Win10/64 ?? Or Linux ?
Show a peace of code

----------------------------------------------------------------------
HappyHippo · 2018-09-13 06:56

Hello Andreas,
the whole scenario is on a WindowServer 2012R2
MSSQL Version 14.0.1000
SQL Server Vative Client 11.0

Lazarus 1.8.4 64Bit and zeosdbo-7.2.4-stable
An exemple project is in the attached files
best regards

----------------------------------------------------------------------
orionyx · 2018-09-24 21:27

Check to see that your encoding on the databases you are accessing is
utf8, and your collation sequence is utf8-unicodvary e-ci. Then those
nasty messages should go away.
But be careful of timestamp, date and time encoding - they vary a lot
between databases.