First time here? Check out the FAQ!

I'm not able to validate a database

0 votes
asked by (120 points) about IBAccess
edited by

I am new to IBAccess and don't really know how to use it. I need to learn, but I don't know where to go. I need some documentation about its features, troubleshooting guides, and error messages.

At the moment I am trying to validate, backup, and restore (VBR) a database. When I try to validate it, I get an error message: "Bad parameters on attach or create database. Secondary server attachments cannot validate databases". I am trying to validate a Firebird database with a .gdb extension.

Background: Working for a company that does professional fundraising for non profit organizations. We use predictive dialers to contact people and ask them to donate. We upgraded to a system that runs off a Firebird database. I am not familiar with Firebird/Interbase/IBAccess. I did not create the database but I need to be able to perform maintenance on it. The company we bought everything from charges nearly $200/hr for support and we just cannot afford it. Can you help?

1 Answer

0 votes
answered by (132k points)
edited by

First of all, you need to know that there is no documentation available, but you can contact the developers and ask for instructions. You can get in touch with them using the email address from the About menu:

enter image description here

In order to fix the error, you need to make sure that nobody else is connected to the database. Also, in order to validate the database, you need to use the Administration account because this process requires exclusive access from either SYSDBA or the database owner. Check the official FAQ page for further details.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register