I'm not able to validate a database

Question

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?

Answer 1

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:

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.