MSSQL Data read only

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 24.01.2018, 11:17

MSSQL Data read only

Postby hoedlmoser » 24.01.2018, 11:30

Dear Zeos developers,

in version 7.14 stable I came up with a problem in unit ZDbcDbLibMetadata.pas (Lazarus, MSSQL):
The function "TZMsSqlDatabaseMetadata.UncachedGetColumns" performs two (redundant?) queries for metadata.
In first place 'sp_columns' procedure is called, later syscolumns table is queried with hard coded collation order.
If the database collation is anything else but "Latin1_General_CS_AS", this query will return an empty result set and cause any data to be read only!
To solve the issue I just deleted the collation directive and recompiled the package, but this is just a quick and dirty solution and I don't know if it might have any side effects.
Unfortunately Lazarus doesn't have a suitable debugging tool but Wireshark shows me that ZConnection queries the database collation and therefore it should be available to the function.

kind regards

Gold Boarder
Gold Boarder
Posts: 671
Joined: 17.01.2011, 14:17

Re: MSSQL Data read only

Postby marsupilami » 25.01.2018, 19:39

Hello hoedlmoser,

this has been fixed in Zeos 7.2. Althoug Zeos 7.2 is still in Beta stage, it already works better than Zeos 7.1. Could you please switch?

With best regards,


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest