Subject RE: [firebird-support] Need help accessing 1.5 embedded in old Clareos product
Author Helen Borrie
At 03:52 AM 8/04/2008, Chris Levine wrote:

>>Hi all. I hope someone on this list can assist me.
>>We use Clareos CrossCut 4.0, which has an embedded admin db of Firebird
>What do you mean by "embedded admin db of Firebird 1.5"?
>--> Firebird is the "repository" database for the application.

Databases: there are two databases.

-- One will be your user database, located (probably) somewhere near the application. The naming convention for Firebird databases is ".fdb". It's not a requirement, though. You're looking for a file that grows.

-- The other is the security database, security.fdb. That is located in the root directory of the Firebird installation.

"Embedded" has a specific meaning in Firebird. If this is a multi-user application and the "users" you refer to are Firebird users then "embedded" is not applicable....but.....

>> Clareos is now out of business so I can no longer get support from
>>them. I am attempting to reset users using the isql utility and I keep
>>getting "database unavailable" when trying to connect.
>What do you mean by "reset users"?
>--> I have a sql statement to update a table to reset inactive
>application users. (not Firebird users)

Would you please provide that statement.

>> I can't even seem to connect to the sample db.
>The "database unavailable" message comes from one of two causes:
>1) The Firebird server isn't running
>2) You're trying to access a database that an embedded application is
>already connected to.
>--> I discovered (through a search) that I needed to add the server name
>since I was connecting via RDP. However, the connection will not
>recognize the SYSDBA user and password. The application owners may have
>created their own user and password?

The SYSDBA password is set at server level. It won't be "masterkey", in case that is what you are trying. The vendors should have supplied you with the password they set. If so, be aware that passwords are case-sensitive.

>The application owners are now out of business and I am trying to
>activate the application super-user through the "back-end" so I can log
>into the application "front-end". I am not familiar with Firebird
>except that this application uses it. (they changed from SQLServer in
>their last release)

OK, in case you don't have the SYSDBA password, there is a way around this. It is it's reasonably well-known but I'm not willing to publish it here and I ask that others don't, either.

Contact me privately if you want instructions...state clearly in the email what you want to do and explain why. Include your company details. CC the email to your company superior and include a note to him/her that I won't reply until I get confirmation.

^ heLen