Subject Re: Multi-threaded simultaneous isc_attach_database calls create problems
Author ericcamelot777
--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:
> > We have Firebird 1.5.2 SuperServer and our client application creates
> > new threads for each database connection. When two connection
requests
> > occur simultaneously in our multi-threaded environment, a call to
> > isc_attach_database is made, and then another call to
> > isc_attach_database occurs before the first call has returned, and
> > neither call returns.
>
> It seems you are using local connection. You have to use network
connection, e.g.
>
> "localhost:d:\mydb.fdb"
>
> Ivan

Yes I was using a local connection, and using the
"localhost:d:\mydb.fdb" format seems to have fixed the problem.

Looking through the documentation, however, I could find no
prohibition against using a local connection in this manner. Am I
missing some documentation?

Also, what performance differences are there between the two
connection methods?

Thanks!