I have made suggestions to get you pointed in the right direction, however be aware that troubleshooting your SQL Server is beyond the scope of the support we provide for AyaNova. I did a quick search on the Internet and I came across recommendations and suggestions on what could be done to identify what is happening on your SQL Server as there is something defintely occurring outside of AyaNova - I would recommend that you do a search of "the server is not responding" or "timeout expired" or "SQL Express performance" etc.

As for the issue of moving your SQL database to another computer,  I recommend that you refer to Microsoft documentation on moving a SQL Server database. 

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

but the funny thing is the only reports that fail are the reports that are detailed .

also since i am reinstalling a new database i will also need a new lic. key to be sent i tried to update the lic. and i state could not validate lic.

so i am guessing that the lic key is expired ? i thought i read in the email i needed to update the lic. buy 2.28 and rolled the new server back to that date before installed but it didnt work.

so if possible can you email me a new key .

is there any performance tips for the firebird database.

reason i ask is with the sql database it only takes about 3-5 sec to open a workorder . but with the firebird database it takes about 10-15sec. . this was the main reason we went to sql .but since we cannot figure out what is causing the timeout on the sql database on detailed only reports . i am starting over . i also did reinstall the whole database and system last week still had same issue.

the other wierd thing is i cannot even open a new detail report(create one) so i really think this is some issue with the software to some degree. ( i would blame Microsoft,  but thats not nice)..

What would be recommended is to continue to change aspects until you narrow down at what this occurs - always being sure to perform testing on the actual local computer, so you are not also adding network issues into it.

For example: Is this Firebird database installed to the same computer as when it was SQL?

If a different computer than when it was SQL - what is the same about the two computers?

Please note that if it is taking 10 - 15 seconds to just open a workorder, especially any workorders after the very first one opened of that program session - there would indicate still an issue with performance on this computer.   The AyaNova v3 Manual section Performance Optimization starting on page 571 identifies a list of common issues to do or not do that affect performance.

AyaNova Sales & Technical Support

http://www.ayanova.com

since i updated it to the 3.1 version . it now fails instantly . before it took a few (60sec or so)

like i said i installed firebird and am going forward . will leave the other database alone for now until i can figure out why it works on everything but a detailed report .

it is just frustrating

I've also posted on this forum to ask if anyone else is experiencing this so that you could compare computers for narrowing down the cause.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com