Zeoslib Portal

Thanks, very simple Qry := TZReadOnlyQuery.Create(nil); Qry.Connection := pCon; with Qry do begin SQL.Text := 'Show variables like '+QuotedStr(pVarName); Open; case Fields[1].DataType of ftString: Result := Fields[1].Value; ftBlob: Result := Fields[1].Value; ftMemo: Result := Fields[1].Value; ftFmtM...

Hello with Zeos 6.x i made a function that Result the size ( integer )r of max_allowed_packet and worked, now with zeos 7.x the same function give me back a Bytes result...is there a way to change back or any other walk around?

thnks

Hello, only for experience sharing: I rewrote all DB Libs for accepting AbstractConnection instead ZConnection, but the problem still was there. Then I rewrote again accepting ZConnection and rewrote all source for calling function Datamodule.zConnection instead of Query.Connection...WORKS!! I Dont ...

hello, only for sharing experience : After rewriting all my Db Library function for accepting "AbstractConnection" the problem was still there, However I rewrite ( again ) passing the TZConnection, and changed all calling from source code with _DataModulde.zConection instead Qry.Connection...

libmySQL51.dll Upgrade. Quickly :) See here . Seem stupid but i can't find the .dll ! Of course i have a timer that ping each minute... Do you disable the timer when you pass the connection to an other form and do something else on it? Remember, one connection can do one thing at a time. If you hav...

libmySQL51.dll server is setted well, ( 28800 ) infact the same application of WinXp never expired i upgrade from zeos 6.2 to 7.2 only for fixing this problem...and i discover the difference from zQry.Connection to zQry.AbstractConnection... Of course i have a timer that ping each minute...but on Wi...

I still couldn't get what exactly is the problem. TZAbstractConn := TZConn should always work The problem is the opposite: TZconn := TZQuery.Connection ( Abstract ) because my DB functions unit paramaters as always a connection, i was used to pass the ZQuery.connection, now thanks aehimself i pass ...

@ aehimself Perfect ! Thank you So the perfect way of programming is - DataModule with Just ONE ZConnection each use of Query setting as connection the DataModule.ZConnection ? Now casting works but very I receive often the "MySql as gone away" message should i use Query.connection := Data...

Thanks for reply, because i have a common unit library with a lot of many DB generic function, each of this has as parameter TZCOnnection, but i can not pass Query.connection because it's an abstractConnection type. So you suggest to change parm type to AbstractConnection? Is then possibile create a...

Hello, what is the best way to pass the connection information from one Query to Another....the connection property is type of AbstractConnection and not as TZConnection...

Thanks Advance

Hello marsupilami, thanks for reply. I don't want you spent time for fixing problem for obslote db, but what i was asking if is my fault, because zeos 6.3 connect with MySql 4.1 and 5 with the same dll too. With 7.1.4 i had to change .dll that unfourtnately doesn't work. MySql 4.1 is old ok, but is ...

Protocol on zConnection was still on MySql-4.1 , changing on MySql5 works....but is strange.

How can I connect to MySql 4.1?

Hello I've just reinstall ZeosLib 7.4 stable on Delphi2007, I have to change every zQuery.connection to zQuery (AbstractConnection ) but I can compile However just start connection I GET "Access Violation in module libmysql.dll" what happend? last compiled with 6.3 works well. Thanks PS I ...

Hi!
I have a problem. :D
I have Zeos 6.6.4 and i use sqlLite.
when i open the query it's everything ok.When i try to make a query or use a table i have an access violation error.
I try tu use also the 6.6.3.

How can i resolve?

Thanks

Hi I'm trying to connect MySql server 5.0 with ssl but I don't Know How pass ssl setting to connection component I already tryied passing in properties string ( --ssl_ca='' etc ) but it seems ignore it. I found MYSQL_OPTIONS in zPlainMySql41.pas but I Don't know how to pass this record to my connect...