Zeoslib Portal

I found out that I could get the data to be retained between sessions by removing some of the code that I had added trying to fix this before. I removed calls to this procedure that I was calling after checking the database against a directory of CREATE TABLE statements. procedure TDbFunctions.Refre...

Here is the section of dfm that codes for our TZConnection. In the code only the Database property gets changed, IIRC: object dbConnect: TZConnection ControlsCodePage = cCP_UTF16 Catalog = '' HostName = '' Port = 0 Database = '' User = 'SYSDBA' Password = 'masterkey' Protocol = 'firebirdd-2.5' Left ...

Hi I am working on an application (Xe5, zeos 7.1.4, Firebird 2.5 Embedded) that is a translation of a MySQL system. The first form we handle on startup shows a group of data-aware controls hooked up to a TZQuery with "SELECT * FROM mast WHERE live = 1" I enter the data and Post, then close...

Hello Mark, I have been trying it for a while. Even disconnecting didn't help. I have modified it so that creating the data now happens in the main thread, and I am still getting errors. Which errors do you get? Do you have an example program on what you try to do? One of the confusing things is th...

Thank for the answer, Jan I have been trying it for a while. Even disconnecting didn't help. I have modified it so that creating the data now happens in the main thread, and I am still getting errors. And now when I got to read tables after getting back in, I am getting: SQL Error: no permission for...

More explanation: It could be that those problems are arising because I have a little utility I wrote connected to the same database open while running Delphi and the main application. That happens in some cases. But I am also getting error -902 when trying to disconnect the database in the main thr...

More explanation:

It could be that those problems are arising because I have a little utility I wrote connected to the same database open while running Delphi and the main application.

---
Mark

Here is some extra info on this: If I use the TZConnection objects used in the main thread, from the main datamodule, it seems to work. I only get this issue: either the tables I am creating not being seen, or when trying on the main thread to diconnect then reconnect I get: I/O error during "o...

Hi

I have a job that runs a background thread adding new tables. When it is finished I have to close the app and reopen it to see the new tables.

What is the right way to pick them up immediately?

TIA
Mark

Thanks,

We have solved it. It seems that you need all the dlls in the same directory as the exe. I had thought I was doing that, but must have missed one. Now it works.

marsupilami wrote: you should check out the Zeo 7.2 branch from the subversion using the URL http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2.#
Jan

That link gives me the 404. Not this 404: https://upload.wikimedia.org/wikipedia/ ... 4vitfr.jpg
The other one.

---
Mark

Hello Mark, Usually if you leave the host name blank and the library is located next to the executable everything should work fine. Did you also copy the rest of the firebird embedded stuff int your directiry? Like the icu*.dll and msvc*80.dll files? Probably the fbembed.dll cannot be loaded withou...

I tried moving the directory of dlls to C:\Program Files (x86)\firebirdeb\, but still got the same error, and set LibraryLocation to match. Could it have anything to do with running on a 64-bit machine? This is surprising, because we were recently trying out SQLite, which required a DLL dropped into...

Hi I am trying to convert a program in Delphi Xe 5 using zeos 7.1.4-stable to use firebird, protocol firebird-2.5. I hjave copied and renamed according to the instructions all the DLLs, but when I set Connected := true on it, I get this error message: None of the dynamic libraries can be found or is...

Hi We are converting a project from MySQL to SQLite. The DB library we are using is Zeos 7.1.4. We have run into a problem: SUM(field) shows up in TZQuery as a TWideStringField. We have code that uses the field type to alter behaviour. so that functionality is not working correctly. We need SELECT S...