firebird-devel

[Firebird-devel] Fb 3 - cannot get additional connections?

[Martijn T. <m.t...@up...>]

Hi all,

It's been some time, but I'm finally diving into Firebird 3 :-)

I've installed build 3.0.0.29789, started it as an application:
"C:\Program Files\Firebird\Firebird_3_0\firebird.exe" -a -i -p 3054

Firebird authentication fails - something has changed there - 
but Windows authentication works.

However, 1 connection to a database works, additional connections
fail with "file in use by a process".

Got any clue?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Re: [Firebird-devel] Fb 3 - cannot get additional connections?

[Alex P. <pes...@ma...>]

 On 02/23/12 13:14, Martijn Tonies wrote:
> Hi all,
>
> It's been some time, but I'm finally diving into Firebird 3 :-)
>
> I've installed build 3.0.0.29789, started it as an application:
> "C:\Program Files\Firebird\Firebird_3_0\firebird.exe" -a -i -p 3054
>
> Firebird authentication fails - something has changed there 

What exact message do you get?
Sooner of all you should initialize security database using:
gsec -add sysdba -pw masterkey
pay attention - not masterke is default, but certainly any other
password is OK

> - 
> but Windows authentication works.
>
> However, 1 connection to a database works, additional connections
> fail with "file in use by a process".
>
> Got any clue?
>

Try to add "localhost:" before file name if you use TCP.

Re: [Firebird-devel] Fb 3 - cannot get additional connections?

[Martijn T. <m.t...@up...>]

Hello Alex,

>> It's been some time, but I'm finally diving into Firebird 3 :-)
>>
>> I've installed build 3.0.0.29789, started it as an application:
>> "C:\Program Files\Firebird\Firebird_3_0\firebird.exe" -a -i -p 3054
>>
>> Firebird authentication fails - something has changed there
>
> What exact message do you get?
> Sooner of all you should initialize security database using:
> gsec -add sysdba -pw masterkey

Aha, interesting.

> pay attention - not masterke is default, but certainly any other
> password is OK
>
>> -
>> but Windows authentication works.
>>
>> However, 1 connection to a database works, additional connections
>> fail with "file in use by a process".
>>
>> Got any clue?
>>
>
> Try to add "localhost:" before file name if you use TCP.

The message is I get using Windows authentication is:
" I/O error during "CreateFile (open)" operation for file 
"E:\TEMP\FB3TEST.FDB"Error while trying to open fileThe process cannot 
access the file because it is being used by another process. "

I'm using the database with the full hostname (machine/port).

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Re: [Firebird-devel] Fb 3 - cannot get additional connections?

[Dmitry Y. <fir...@ya...>]

24.02.2012 11:26, Martijn Tonies wrote:
>
> The message is I get using Windows authentication is:
> " I/O error during "CreateFile (open)" operation for file
> "E:\TEMP\FB3TEST.FDB"Error while trying to open fileThe process cannot
> access the file because it is being used by another process. "
>
> I'm using the database with the full hostname (machine/port).

You seem using the Classic mode but having the exclusive database access 
turned on. Setting SharedDatabase to true and SharedCache to false in 
firebird.conf should help.

Alternatively (SS mode), you need SharedDatabase = false, SharedCache = 
true and start firebird.exe with the -m command-line switch.


Dmitry

Re: [Firebird-devel] Fb 3 - cannot get additional connections?

[Martijn T. <m.t...@up...>]

Hello Dmitry,

>> The message is I get using Windows authentication is:
>> " I/O error during "CreateFile (open)" operation for file
>> "E:\TEMP\FB3TEST.FDB"Error while trying to open fileThe process cannot
>> access the file because it is being used by another process. "
>>
>> I'm using the database with the full hostname (machine/port).
>
> You seem using the Classic mode but having the exclusive database access
> turned on. Setting SharedDatabase to true and SharedCache to false in
> firebird.conf should help.
>
> Alternatively (SS mode), you need SharedDatabase = false, SharedCache =
> true and start firebird.exe with the -m command-line switch.

Excellent, this works.

Sorry for not keeping up and having to bother you all with this ;-)


So, let me get to understanding and supporting Stored Functions and Packages
and how to debug those. ;)

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!