Subject | Firebird 2.5 - Concurrent access of Embedded vs. SuperClassic |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-10-14T19:14:09Z |
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/
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/