Zeoslib Portal

The code for the test project is as shown below. It tries to connect to the sample PostgreSQL Sakila DVD Rental database. unit Unit1; {$mode objfpc}{$H+} interface uses Classes, SysUtils, db, FileUtil, Forms, Controls, Graphics, Dialogs, DBGrids, StdCtrls, ZConnection, ZDataset; type { TForm1 } TFor...

I've been away for a while and now I'm back to this project. Unfortunately, it still doesn't work for me. I'm using Lazarus 1.6.2/FPC 3.0 on Windows, I've installed PostgreSQL 9.5.6 and Zeos 7.1.2 RC. I've copied all the relevant DLLs from my PostgreSQL \bin directory to the sample Lazarus project d...

And have you tried to upload client library files to the system directory SysWOW64(or System32)? Michal Hi there Michal & thanks for replying. Are you refering to these files zlib1.dll libeay32.dll libiconv-2.dll libintl-8.dll libpq.dll libxml2.dll libxslt.dll ssleay32.dll that you listed in yo...

Hi there everyone,

I just wanted to know if this problem has been fixed maybe in the trunk version.

Thanks a lot.

JD

Thanks a lot for your reply EgonHugeist . I posted the same question on the Lazarus forums & miab3 posted responses saying copying the folowing files to the application's directory will make it work zlib1.dll libeay32.dll libiconv-2.dll libintl-8.dll libpq.dll libxml2.dll libxslt.dll ssleay32.dl...

Hello JD, sooo - I checked the Zeos sources. By default Zeos uses soft commits or "commit reatain". You might want to look that up in the Firebird Book from Helen Borrie or in the Firebird 2.5 Language Reference. The soft commit combined with tiReadCommitted might lead to users not seeing...

Thanks a lot for your replies Jan & Michal. I'll put each of your suggestions to the test & report on my findings.

JD

Hi there everyone, I have an n-tier application in production written in Lazarus 1.6/FPC 3.0 & based on Firebird 2.5 (SuperClassic configuration) and Zeos 7.2RC. Recently, some of my users have noted that changes made by some users are not seen immediately by other users. The code I used to set ...

Hi there everyone, I'm having a rather curious problem. I use Zeos 7.2 RC along with Lazarus 1.6/FPC 3.0 Win32. I also have PostgreSQL 9.5.1 Win32 installed. I wanted to connect to a PostgreSQL database in the Lazarus IDE using TZTable & TZQuery and browse the results in a DBGrid. Anytime I try ...

Can anybody please give me some clues? I will really appreciate it.

JD

Hi there everyone, I'm trying to implement a connection pool for an application of mine. I previously used Cary Jensen's connection pool but I later decided to write one of my own. Because I use Zeos 7.1.4 on Lazarus 1.2.6, I wrote a small class to handle connections to my database. However while de...

JD , Btw. You don't need to open the TZQuery before assigning the new statement. Drop the line which speeds up you code.. Thanks for the tip. I had been wondering about the necessity of the 'Open' and 'Close' statements in the code snippet. I've since removed them and the code works perfectly as yo...

Problem solved!!! I just learned that a ZQuery's parameter list is recreated whenever a new SQL is assigned to the query. This also explains the discrepancy in the object inspector and the parameter count in the first picture I attached. So it was not a bug after all . Once I realised this, I modifi...

I've incorporated the changes you suggested and the changed code is as shown below: cmdUpdateFoyer: begin // read the size of the stream sent by the client LStreamSize := StrToInt(LClientContext.Connection.IOHandler.ReadLn); // read the stream LClientContext.Connection.IOHandler.ReadStream(LStream, ...

Thanks for the tips, Michael. I'll make the changes you suggested and I'll let you know how it turns out.