64Bit operating systems and AyaNova stand-alone

[FORUM NOTE: The below is no longer relevant to AyaNova version 5 or higher as now the stand-alone installation of AyaNova is fully compatible with 64-bit operating systems]

If you install AyaNova onto a 64bit operating system via AyaNovaSetup.exe, by default the AyaNova database is a stand-alone embedded Firebird Server database located at %AllUsersProfile%\AyaNovaData

If you are running a 64bit operating system and attempting to connect to the stand-alone AyaNova database, you will get the error: " "

AyaNova was unable to start

Depending on how early in startup the problem occurred,
a detailed log of the problem with suggestions may have
been saved to the file AyaLog.txt
located at: file:\C:\Program Files (x86)\Ground Zero Tech-Works Inc\AyaNova

Error details:
Unhandled Exception:
Exception has been thrown by the target of an invocation.
Inner exception: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

<P This is because the stand-alone AyaNova database uses the embedded stand-alone Firebird Server 2 (there is no configuration by the user installing, it installs everything needed by default), and this embedded stand-alone Firebird Server 2 is not supported for 64bit operating systems

But do note that you can with no issues run the AyaNova program itself on a 64 bit OS and connect to a networked AyaNovaFirebird database that is on this same 64bit computer, or connect to another computer’s Firebird Server networked AyaNova databaseor a SQL AyaNova database on another computer, or a SQL AyaNova database onthis 64bit operating system computer.

If you are trialing AyaNova on a 64 bit OS, please follow the steps in the AyaNova 4 Help file to set up AyaNova to use a network Firebird Server see opnline Help documenation - just ignore step 2.b otherwise you will get that error above.

Do note that you can also have a 64bit OS have a SQL (Express or Server) AyaNova database too - but because you can not access the embedded Firebird Server 2 without errors, you can not set up a AyaNova SQL database directly on a 64bit operating system following the steps in the online Help documentation as to create the SQL AyaNova database requires accessing the embedded Firebird Server, which would just give you errors.

So instead you would follow the SQL setup steps on the 64 bit operating system EXCEPT where the steps are about creating the SQL AyaNova database - these must be done on a32 bit operating system and than move/restore from backup the AyaNova SQL database to the 64 bit operating system.

If you have any questions, do contact support@ayanova.com providing which SQL you have (SQL Express or SQL Server 2005, SQL Server 2008, etc) and what 64bit operating system you have, etc along with your question.

  • Joyce

Just wanted to make a note here that the newest version of AyaNova 5 that will be released this spring will be using the latest Firebird stand-alone server which is confirmed compatible with 64bit operating systems - so 64 bit users won’t encountered posted above if they want to run AyaNova in the default stand-alone computer configuration.