I am sorry to hear that you do not have a backup as that would be an easy fix by reverting to the database from before the issue occurred.

I am not sure what you mean by a "copy" as you are running the AyaNova configured for network Firebird Server use, and any direct access of the database will more than likely cause database corruption.

Once the Firebird Server is "serving" the database, the database file itself would never be anti-virus scaned, never be directly copied, never be moved as this will cause database issues - which may be what the issue with your database is caused by. We provide steps on how to backup the AyaNova database when using the network Firebird configuration that creates a "snapshot" of the database, and than database snapshot is what is backed up.

If ever the AyaNova database that is configured for network Firebird Server use needs to be directly moved or copied, you MUST shut down the Firebird Manager.

By direct email to support@ayanova.com, send the following and we will go from there:

•  Shut down the Firebird Manager via Control Panel on the server
• Using WinZip, zip up the AYANOVA.FDB database file
• Attach to a direct email to support@ayanova.com,
• include your AyaNova Administrator username and password
• reference this Forum topic http://forum.ayanova.com/Topic3329-89-1.aspx in your email so I know what this is for

I will take a look and see what direction we go through from there.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Thanks for reminding all of us the importance of a backup done properly. 

I need to coordinate access to the network server in order to complete the next steps & will send a note when the files are coming your way.

Thanks again -

Gladys

The requested file has been sent & look forward to any suggestions. 

In the meantime have been trying to set up the backup so we will be able to properly backup & restore the info if required & am having difficulties with firebird server:

> C:\Program Files\Firebird\Firebird_1_5\bin>gsec -user sysdba -
> password masterkey
> Your user name and password are not defined. Ask your database
> administrator to
> set up a Firebird login.
> unable to open database
> C:\Program Files\Firebird\Firebird_1_5\bin>gsec -user AyaNova -
> password letmein
> Your user name and password are not defined. Ask your database
> administrator to
> set up a Firebird login.
> unable to open database

The person who originally installed Firebird is no longer available  & as such am wondering if there is another method to define the name & password.

Thank  you for all your assistance.

Gladys

If you have any further questions on this, zip up your AyaNova.exe.config file using WinZip and attach to a private message or directly to support@ayanova.com as also requested in the previous reply to send the AyaNova database and other info.

[Edit as of 8/30/2007: Received the database file from the AyaNova user, and it was corrupted which was the issue. As the AyaNova user had not entered any data yet, provided direct instructions to the AyaNova user to start fresh - uninstall AyaNova, manually delete the corrupted AyaNova database, install AyaNova from scratch, setup AyaNova for network use, apply the activation key to unlock and begin again. AyaNova user has also implemented backup procedure.]

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com