| Subject | RE: [firebird-support] Need help accessing 1.5 embedded in old Clareos product |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-04-07T23:37:25Z |
At 03:52 AM 8/04/2008, Chris Levine wrote:
-- 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.....
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
>>Hi all. I hope someone on this list can assist me.Databases: there are two databases.
>>We use Clareos CrossCut 4.0, which has an embedded admin db of Firebird
>>1.5.
>
>What do you mean by "embedded admin db of Firebird 1.5"?
>
>--> Firebird is the "repository" database for the application.
-- 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 fromWould you please provide that statement.
>>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)
>> I can't even seem to connect to the sample db.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 "database unavailable" message comes from one of two causes:
>
>1) The Firebird server isn't running
>or
>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 application owners are now out of business and I am trying toOK, 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.
>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)
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