Page 1 of 1

Zeos error with Firebird 2.05

Posted: 27.01.2009, 18:12
by Prometeus
Hello,



I was testing my applications with the brand new release of Firebird 2.0x series, the version 2.05. I can connect with the DB but it fails when I do a SQL command like this:

SELECT CURRENT_TIMESTAMP AS server_time FROM RDB$DATABASE

I got an 'access violation' error. Looking at the error log it seems the problem is in 'UncachedGetColumns' call that belongs to 'ZDbcInterbase6Metadata.pas' unit. I don't know whether this is an issue like the one appeared when version 2.1 of Firebird was released.

Anyone else experienced this behavior?


Regards.

Posted: 27.01.2009, 22:03
by seawolf
I've never do a query like that, anyway tomorrow I'll do a try with Firebird 2.1.1

Do you use Firebird embedded or server? Linux or Windows?

Posted: 28.01.2009, 13:37
by Prometeus
Hello, Seawolf,



This problem occured with the new Firebird 2.05. With Firebird 2.1.1 it doesn't occurs!

I use Firebird SuperServer on Windows Server.


Thanks for your attention.

Posted: 29.01.2009, 12:04
by seawolf
I have the same problem with Firebird 2.0.5 both embedded and SuperServer.
But the same code works as expected using FB 2.1.1 and 2.0.4

Anyway I'll do more tests.

Posted: 29.01.2009, 18:18
by tflessak
After update to 2.05, I started getting this error too (exception)!
I think Firebird team have changed samething in this new release.

Posted: 30.01.2009, 06:47
by fcodebue
I try with a new installation of firebird 2.0.5 and zeosLib 6.6.4

no problem to open a zconnection
no problem open a zquery with this SQL

I use alias to connect to database, and you?

Posted: 30.01.2009, 15:15
by tflessak
I didn't use aliases (even on 2.04).
I tried both embedded and SuperServer.

That's really wierd.

Posted: 30.01.2009, 17:38
by fcodebue
tflessak wrote:I didn't use aliases (even on 2.04).
I tried both embedded and SuperServer.

That's really wierd.
try to copy firebird\bin\fbclient.dll to

<system32\fbclient.dll
<system32\gds32.dll

I'm not sure that it's changed... but try it...

Posted: 03.02.2009, 21:59
by Prometeus
Hello, fcodebue,



I already do that on all PCs. To no avail. Looks like Firebird 2.05 changed something in the protocol.

Thanks.