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!