A bit more than one year after the first 2.1 alpha release in March 2007.
Since then there were again and again forum messages that Zeos does not work with FB 2.1. The reply sometimes was 'FB 2.1 is still alpha (or beta). We are waiting for the final release to start Zeos changes. '
The final release is there, what is the current status or plans for Zeos with Firebird 2.1?
The last Zeos version I have tested was Zeos 6.6.2 from Dec 07 and it didn't work with FB 2.1
I do the same. A test program runs ok with fbclient.dll from FB 2.0.
When replace the dll with fbclient from FB 2.1 (and replace all other required files) I have an Access Violation.
Sandeep, I think you forget to replace the fbclient.dll on your Windows\system32 with version 2.1
I already try with Fb 2.1 and yes there is a problem that martinalex said. The problem is little strange, the first attempt to connect will fail but the second call will success, so there is a change in FB client API. Now the problem how can we know the new client API? where to get that information? Sorry I'm not have this knowledge now.
Thank you for this tip.
>> the second call will success
This is a strange behaviour.
My program stoped after an unsuccessful connect, so I never tried a second connect.
At least I come across the connect access violation and can test what else does work with FB2.1 and what not.
This is a workaround, but I doubt if Zeos with FB 2.1 is stable.
the second connect works ok and the read access with FB 2.1 looks normal. But when I try to insert a lot of data I have access violations for each insert. After a few hundred access violations my program crashes with stack overflow.
I have checked Zeos SVN, there are no changes since version 6.6.2 for Firebird.
At the moment there is no way to use FB 2.1 with Zeos.
It is not urgent since FB 2.0 is mostly sufficient, but 2.1 has some interesting new features.
Since I don't have the knowledge to fix those Zeos components I have to wait for a new Zeos release with FB 2.1 support or have to switch to other components.
I am working on something on Zeos and have changed following files. If you want you can try them and see if they work. These are just for testing purpose please don't use them in your real applications.
I look include directory from FB 2.1 but it only header file. What reference to build FB 2.1 plain driver? Someone in here have experience to build database driver? I completely new for this stuff
I think you best start from the Interbase API documentation. This should give you a good impression about the workings of FB as far as I know. You'll certainly find most of the structures in the IB documentation back in the header files (include dir).
Unfortunately this doesn't tell you more about the new additions in FB since they split off from IB.
Who knows where you get these differences from? I think this mainly concerns new functionalities that are very FB specific (and thus not that important to Zeos), but you never know how these functions can help performance in the newer drivers.
Take a look to document Firebird 2.1 Release Notes, section Changes to the Firebird API and ODS. For example :
Additions to the isc_database_info() Structure V. Khorsun
The following items have been added to the isc_database_info() function call structure:
isc_info_active_tran_count
Returns the number of currently active transactions.
isc_info_creation_date
Returns the date and time when the database was [re]created.
To decode the returned value, call isc_vax_integer twice to extract (first) the date and (second) the time portions of the ISC_TIMESTAMP. Then, use isc_decode_timestamp() as usual.
When I try to connect FB 2.1 I get an error abaout isc_vax_integer ,
may bee this changes cause the problem with FB 2.1 on Firebird20 driver ?!
.