Zeoslib Portal

Jezz! It should be a less complex way to do that! I exepcted to see the compilation of those requiered units, a minor change on the position of the defines test but it seems that not. I'm testing UniDAC which supports various databases, its approach is that for each supported server there is a compo...

I used some time ago Zeos and remember that you can remove support for some database just comment the define in Zeos.inc. I just did it but for my sorprise ZInterbaseToken uses ZPostgreSqlToken which isnt compiled if ENABLE_POSTGRESQL isn't defined. ZPostgreSqlToken uses ZMySqlToken and ZOracleToken...

Hi.

To which database (MySQL, Oracle, etc.) are you connecting?

Regards.

Hi. FWIW, I installed on Mac OS 10.4.8: - Lazarus 0.9.24 - Zeos 6.6.2 RC (remove libc unit from some sources) - Firebird 2.0.3 classic - Make a link to /Library/Frameworks/Firebird.framework/LIbrary/libfbclient.dylib in /usr/lib/libfbclient.so Then connect to Firebird 2.0.3 running on windows. Attac...

mmmm....

I still not quite shure if I will stay with Lazarus/ZeosLib, I dont use Zeos in Delphi.

Let me think about.

Regards.

actually I know very little about firebird), but does it use cursors that should stay open?

mdaems:
Is someone maintaining IB/FB driver?

mdaems wrote:Could somebody implement the hard commit/(re)start transaction functions on Plaindriver and zdbc level?

I think that will broke a lot of code since hard commit in IB/FB closes all opened cursors.

Hi guys, ssamayoa I would really be very interested to understand what is that makes you say that "Disconnect / connect is a very expensive method for hard commit to occur"? At current LAN speed (10/100Mbps) and with the current server speed there is no much impact on connect/discobbet an...

I dig a little into sources and found: 1. TZConnection.StartTransaction method doesnt call driver's StartTransaction. It seems that other supported ZeosLib RDBMS doesn'n need explicit start transaction after commit as Interbase / Firebird needs when hard commit occurs. 2. TZInterbase6Connection.Open...

Some findings?

I was thinking about the same problem but still dont get into the sources.
What about hard commit when no dataset is opened?

Disconnect / connect is a very expensive method for hard commit to occur.

I will better see what is inside sources...

Regards.

Sorry, I wrote in a hurry and omit a few words:

"Autoinc fields don't exists on Firebird, you must provide field value from client side (before post is a good point to put it) or server side via before insert trigger."

Regards.

Autoinc fields don't exists on Firebird, you must provide from client side (before post is a good point to put it) or server side must provide it via before insert trigger. If you have a before insert trigger to set the "autoinc" field, I suspect you have persistent fields for your TZQuery...

Thanks.

I'm in the middle of some JVCL component conversion for lazarus, when I have a little spare time I will see if I can make it work.

Regards.

I enabled USE_SYNEDIT in Zeos.inc but SQL editors still use TStringList editor.

Is Zeos able to use SynEdit or is lazarus limitation?

Regards.

I'm looking again for lazarus for an OS project.
Is Zeuslib ready for use in lazarus?

Comments on the subject please.

Regards.