Jump to content
Jacek Laskowski

Firedac and simultaneous connection to different version of Firebird

Recommended Posts

Is it possible to connect to two versions of the Firebird server (2.5 and 3) at the same time using Firedac?

Both connections should use a different version of fbclient.dll, how to do it?

Share this post


Link to post
56 minutes ago, Jacek Laskowski said:

Is it possible to connect to two versions of the Firebird server (2.5 and 3) at the same time using Firedac?

Both connections should use a different version of fbclient.dll, how to do it?

I don't know how FireDAC works internally, or how it loads fbclient.dll, but have a look at Activation Contexts, which allow a process to load multiple versions of a DLL at the same time.  Create a context for one DLL and connect to Firebird while that context is active, then create another context for the other DLL and connect to Firebird again.  Not sure if it will work in your situation, but it is worth a try.

Share this post


Link to post
Guest
1 hour ago, Jacek Laskowski said:

Both connections should use a different version of fbclient.dll, how to do it?

I do not use FireDAC but generally, you should be able to access a 2.5 DB using a 3.0 fbclient.dll.

What may give you headaches is if FireDAC when it build SQLs (supporitng cursors) uses 3.0 syntax for your 2.5 DB. Most should work anyway, IMHO.

Share this post


Link to post
Quote

you should be able to access a 2.5 DB using a 3.0 fbclient.dll.

No, older ODS aren't supported for now.

Share this post


Link to post

I tried to use the library from version 3 and for now it seems to work also for connections to the 2.5 server. But I have not written anything to the base yet, only readings.
But is it safe and stable?

Share this post


Link to post
Guest
18 hours ago, Markus Kinzler said:

No, older ODS aren't supported for now.

Marcus, i mean accessing a 2.5 install (on a server, not locally) using a client install with the fbclient.dll from 3.0. Really?

ODS = On Disk Structure, a very server-side concept.

Opening a FB 3 file using a 2.5 server - that won't work because of different ODS. 

Share this post


Link to post
Quote

Marcus, i mean accessing a 2.5 install (on a server, not locally) using a client install with the fbclient.dll from 3.0. Really?

This should work.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×