Zeoslib Portal

No problem, I understand. I created the issue in the bug tracker just in case. I'll try to dig a little deeper (I'm not sure if it's only a Delphi 2009 problem or if it's related to Firebird 2.1 vs 2.0, or if - god forbid - I did something wrong), but I'm still widely unfamiliar with the Zeos codeba...

Hello, I think this is a regression from Zeos-6. An exception is thrown (assert failed) from TZAbstractBlob.GetUnicodeString (specifically "Assert(Len mod 2 = 0);") with large varchar fields (I triggered it first with a varchar(2561)). As far as I know this is way lower than the Firebird r...

Hello,

Maybe not the most useful feedback, but I've tried Zeos v7 under Delphi 2009 (mainly with PostgreSQL 8.1, 8.3, SSL, unicode DB) with no problem whatsoever (except the memory leak reported earlier).

Keep up the good work, it's really appreciated !

What's the actual error you get? sigh... I was writing the error I get is an exception triggered by CheckInterbase6Error() when I notice something. Because the question marks may be OK. That's what catch my attention and I assumed the generated SQL was incorrect. Turns out the beginning of the exce...

Hello, I ran into a problem when trying to do bulk insert using TZQuery.Append/Post. Here's an excerpt of my code in case I forgot something : Query := TZQuery.Create(nil); Query.Connection := Connection; Query.SQL.Text := 'select * from '+TableName+' where 0=1'; Query.Open; Query.Append; Query.Fiel...

Hello, I searched through the SQL reference doc, various forums, ... but did not find any authoritative answer regarding this question : When you change a table structure to add a column(s) using ALTER TABLE ADD..., are the column(s) *always* added at the end of the table structure ? (I know you can...

Hello, With all due respect, I think you didn't read carefully enough the MySQL license agreement (not that license agreements in general are particularly crystal clear). There's absolutely nothing 'shaddy' or misleading in it, and many other vendor use this kind of double-licensing (the prime examp...

I've just tested it with BDS2006+Updates, and it works Ok. Thanks for the commit.

Hello, It seems this bug also appears with Firebird (I use TRUNK_187 with this previous bug fixed). The leak happens upon calling TZQuery.ExecSQL. As it seems to be the error message data not being freed, you can only witness it with invalid SQL. I'm afraid I'm not familiar enough with Zeos codebase...

Hello, Speaking of my own experience with Zeos, we began using it 18 months ago. It's now in production (our applications are somewhat of a niche market, so you likely haven't heard of it), and works really fine with decent speed (typical DB size : ~10^6 rows). However, our database usage is admited...

I found a fix by explicitly copying the string. Replacing : PWideString(Buffer)^ := RowAccessor.GetUnicodeString(ColumnIndex, Result); by : WStrCopy(Buffer, PWideChar(RowAccessor.GetUnicodeString(ColumnIndex, Result))); Warning : WStrCopy() is defined in WideStrUtils.pas present with Delphi 2006, bu...

Hello, I stumbled upon this, which looks like a bug. Basically I get an EOutOfMemory error when I try to access a Fields[x].AsString from a TZQuery when the field is a ftWideString. Bug occurs in ZAbstractRODataSet.pas at line 1195 (for trunk 187) : PWideString(Buffer)^ := RowAccessor.GetUnicodeStri...

There was indeed a conflict with oci.dll from Oracle9 installation, and oci.dll from Oracle-XE.

However, for future reference, skipping Query.ExecSQL works fine.

Thanks a lot for your help.

Ok. Thanks for all the infos. Connection is now working fine. I don't know if it's intented, or documented, or expected, but all I had to do was remove the 'oci.dll' file from the program directory. Which lead to another question : - Connection is fine - I can run SQL scripts against the DB (tables ...

Hello, I'm really sorry having to repost this question, but unfortunately the previous one (along with an helpful answer) was lost during the webhosting switch. I'm having troubles connecting to Oracle (and OracleXE) DB. - Oracle XE (or Oracle) is installed locally - I understand I need a TNS to con...