Subject Re: Confussion over passwords: Tells me my user name and password are not define
Author blizzardb2001
--- In, "Alan McDonald" <alan@...> wrote:
> > We would use the embedded database, however our application connects to
> > two databases simultaneously: one is remote, one is local...
> >
> then you haven't asked the right questions at the right time. Embedded gives
> you exactly that ability. Connect to both a local embedded database AND a
> remote one at the same time.
> You cannot do cross DB joins though.
> Alan
Hmmm.. the way I understood it is that when a database is connected to using the firebird embedded driver, that database becomes locked to just 1 user - so 2 users cannot connect concurrently. That is not a problem for the LOCAL DB, but is a major problem for the remote DB.
Okay, so all we need to do is use the normal driver to connect to the remote DB, and the embedded to connect to the Local DB. So we would have to put both drivers in the same folder, under different names? and then tell our software to connect using a specific driver. Does this sound correct?