Zeoslib Portal

"database driver not found" means exactly that. Which value do you set to the TZConnection.Protocol property?

To me it seems that you use something like the old "firebird-21" protocol. Just switch to "firebird".

Which version of Lazarus and FPC do you use? How is the configuration of you TZConnection object? Can you maybe share a sample application that generates the probelm?

Hello Sakis, after using a lot of time today for finding what is wrong here, I found this bug report: https://github.com/FirebirdSQL/firebird/issues/8110 Essentially the following line in my logs brought me there: libc : FORTIFY: fcntl(F_SETFD) passed non-FD_CLOEXEC flag: 0x80000 So this is a known ...

Hello,

on drivers that need their data fetched into memory, we usually do that internally (dblib) or have the client library handle this (mysql, postgresql).

Could you maybe prepare a small example application that demonstrates the problem?

Best regards,

Jan

Hello,

the problem is that the comment at the end of the script generates an empty statement. Not all databases support this. The follwoing will work:
Best regards,

Jan

Hello,

could you please check if this works correctly with Zeos 8? We don't want to do work on Zeos 7.2 anymore if at all possible.

Best regards,

Jan

As far as TZUpdateSQL goes: Please use it only if you have to. Zeos should handle these things in a lot of cases automatically. If you have to use TZUpdateSQL: Fill in the InsertSQL, UpdateSQL and DeleteSQL properties as needed. Use :<FIELDNAME> in the SQL statamants to have parameters for the new f...

You are not supposed to use commit in the script.

Call TZConnection.Commit after you executed the script successfully.

Hello kikep, RequestLive is a very old property that was remved with Zeos 7.0. RequestLive had the inverse meaning to the ReadOnly property. When RequestLive was set, an updateable result set was requested. So if the manual says you should set RequestLive to true, this translates to set ReadOnly to ...

Hello,

could you please try to create a sample project that shows the error? I use Firebird on a daily basis with TZSQLProcessor and for me it works.

Best regards,

Jan

Hello,

could you please check if the latest 8.0-patches branch from SVN fixes your problems?

Best regards,

Jan

Hello,

we think we solved your problem. Could you please check if the latest 8.0-patches branch works for you?

Best regards,

Jan

Hello marko,

unfortunately there is nothing attached to your last post.

Best regards,

Jan

Hello Joe, this really is strange. In TZQuery the insert statement is auto-generated, how can i manipulate this ? I even don't know, why this " is auto-generated only for my "STATUS" field. Seems mysterious to me... You could use TZUpdateSQL to provide your own statements, so Zeos doe...

Hello Enrique,

usually this would be part of the connection string. Mabe a look at https://www.connectionstrings.com/ can give you an idea?

Please note: We want to discontinue support for ADO. You might want to check if your application works correctly with the OLEDB driver.

Best regards,

Jan