Zeoslib Portal

Problem solved, thank you !

:-))

With other words :

Can I access two (or more) databases with a single ZConnection component ? How ?

Hi again folks, Today I wrote a query that references another database - other than the one in TZConnection.Database SELECT Rendszam,FszgA,FszgB,CI FROM Online FULL OUTER JOIN BUSDATADKV.dbo.Jarmu ON (BUSDATADKV.dbo.Jarmu.FSZGA=Online.CI) OR (BUSDATADKV.dbo.Jarmu.FSZGB=Online.CI) WHERE CI=999 OR BUS...

Confirmed.
Build 113 eliminated both errors.
Thank you again.

Cheers,

Peter

I download the last version of ZeosLib and I think i found the problem. You have to modify ZDbcDbLibMsSqlMetadata.pas at line : 1599 [TableNamePattern] into [AQSNull(TableNamePattern)] from the : with GetStatement.ExecuteQuery(......, [TableNamePattern]) do into the : function TZMsSqlDatabaseMetada...

Hi Rautgigi, Congrats ! You have solved the mem leak problem. TO ALL : Please include this patch in the next release. Hereby I confirm that Rautgigi's suggestion to Dispose variables instead of StringList elements eliminated the problem. Thank you very much. For the other problem I raised : Now I mu...

Next week I must dig myself deep into Zeos' source's internal structure, if I don't get any advice in a reasonable time - the thing I've never done before. Neither with Zeos, nor with any other third-party or native Borland component. I give myself a 20-30 % chance to succeed. As far as I know, tryi...

I use MySQL 4.0 as I mentioned above, but it's no matter from the problem's point of view.

Well, it also occured to my mind that the client dll tricks me. For Microsoft SQL Server 2000 I use one of two files : - ntwdblib.dll 290816 bytes, 2005.05.04, VarFileInfo 2000.080.2039.00 - MSVCR71.dll, one is a renamed version of the ebove, another is - MSVCR71.dll, 348160 bytes, 2003.02.21, VarFi...

Tom,

Never change something that works good without the NEED for change.
In my native language there's a good-old proverb saying the same. My culture has the habit of collecting centuries' wisdom in proverbs. It's a commonplace here that you can trust them without any doubt.

Cheers,
Peter

So, I looked after this issue a bit. The first thing I did was trying another database server. My assumpion was correct, there's no problem at all if I connect to MySQL 4.0 with the same program, without restarting it. I ported the corresponding tables fine. Today I dl'ed the newest CVS build Mark p...

Hi All ! I have ZeosDBO 6.5.1-alpha build at 2004-11-14 03:26:23 - well, not the newest (just looked for the version right now) on Delphi 5 Enterprise. I connect to MSSQL server 2000 via Zeos. Connection is fine. Each time I load a query to TZQuery's SQL property, when I issue an ExecSQL statement f...

Hello folks, I found that if the SQL server cannot execute a query and reports an error ZQuery sometimes throws EDatabaseError, sometimes the generic Exception. I haven't got time yet to investigate when does it throw which exception, but I'd like to reserve the general type for other errors than da...

Hello Mark, There has been another thread discussing the same theme where you suggested me, and I promised you to try the SVN repository about a month before. I've lost that other topic because of the forum movement, but I can give you good news that your changes you made then are working for me ! S...

16. Changed the end of ZDbc.dpk from : ZDbcSqLiteStatement in '..\..\src\dbc\ZDbcSqLiteStatement.pas', ZDbcSqLiteResultSet in '..\..\src\dbc\ZDbcSqLiteResultSet.pas', ZDbcSqLiteMetadata in '..\..\src\dbc\ZDbcSqLiteMetadata.pas'; <<<--- ZDbcASAUtils in '..\..\src\dbc\ZDbcASAUtils.pas', ZDbcASAMetadat...