Subject Firebird 2.5 - Concurrent access of Embedded vs. SuperClassic
Author Thomas Steinmaurer
Hello,

tried the following with the beta/RC versions of 2.5, I'm sure this
worked as advertised, but with final accessing one and the same database
with 2.5 embedded and SuperClassic somehow isn't possible.

I started SuperClassis as an application on port 3051, e.g. with:
"C:\Program Files\Firebird\Firebird_250_3051\bin\fb_inet_server.exe" -a
-m -i -p 3051

Then I have extracted the embedded ZIP file into a folder, renamed
fbembedd.dll to fbclient.dll and put fsql into that directory. In fsql,
I connect to the database with, e.g.:

connect g:\datenbanken\tourism25.fdb user 'tourism' password ...;

The connect works.

I then use fsql in the Firebird\bin directory and use a TCP/IP
connection via the SuperClassic server to connect to the same physical
database:

connect localhost/3051:tourism.fdb user 'tourism' password 'tourism';

All I get is:

ERROR:
Statement failed, SQLCODE = -902
Database is probably already opened by another engine instance in
another Windows session

The only obvious thing I see is, that the SuperClassic server is 64-bit
whereas the embedded server is 32-bit, because fsql and possibly any
other e.g. Delphi-related client is 32-bit as well. So, possibly a mix
of 32-bit vs 64-bit doesn't work?

I'm on Windows 7 Prof. 64-bit.

Any ideas are welcome!

Thanks.

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/