Page 1 of 1

Connection to Firebird Server + Embedded at the same time

Posted: 12.06.2009, 18:30
by SonnyBoy
Hello!
I have a littel problem with the TZConnection.
I try to connect to a Firebird Server and a Firebird Embedded Database a the same time. I need this for a machine control system.
I generate to Instance of TZConnection. With the first i connect to the embedded and with the second to the server. When i now access data, this happens: i retriev data from the embedded whit my LocalConnection and then data from the Server with my ServerConnection. I then try to retriev data from the Embedded with the localConnection again, but the localConnection now tries to recieve data from the server ?!?
Why that? where do i have a mistake? something special in the use of two TZConnections?
(with only one TZConnection and only one database system everything is okay, but two TZConnections and two database nothing works). and i need the access of the two databases at the same time (no switch mode available).
Can someone help me please?
Thank you a lot!

Posted: 16.06.2009, 13:35
by mdaems
This should work without problems.
Only explanation I have is both connections use the same library. Sure both are using a different protocol and dll?

Mark

Posted: 17.06.2009, 08:15
by fcodebue
You prepare your two connections at runtime... could you post some sample code... just for check that your are set all parameters correctly

Code Example

Posted: 18.06.2009, 15:14
by SonnyBoy
This is a code example that doesn't work.
the 3rd request goes to the server but should be on the embedded

Posted: 23.06.2009, 22:56
by mdaems
I see no obvious problems.

Did you check if the connections use 2 different dll's? I'm not sure if it's possible to connect from the 'embedded' dll to a normal server (as is possible with the mysql embedded client library)?

Some fb specialist wants to have a look at this?

Mark