NetCare (9/10/2008)
When running the Firebird to MSSQL utility it hangs at 1%. When testing the connections to the FDB file and MSSQL it gives the green light. It appears to create the MSSQL database, but then gets stuck migrating.
I'm using Windows 2003 R2 and SQL Express 2005. I've followed the instructions o nthe help file to the letter.
Thanks,
GaryHi Gary, unfortunately if you are getting this issue, this means something is not quite right. Either there is a step missing, or the connection strings entered are not correct, or there is something with your SQL that is preventing the database from being created, such as your SQL server computer is overloaded or does not have enough hard drive space or something else. By confirming each step that you have done, and providing specific details on exactly what is your setup and what you are doing, we can help identify what the issue is a cause of. It is always recommended to double-check your steps, and not assume - many support requests are unfortunately because an AyaNova user is positive that they have done all the steps, but then it turns out one or two was not. And to defintely be able to help you troubleshoot, do provide specifics, as it allows us to help figure out what exactly the issue is. Let's first confirm the steps you have performed for the networked AyaNova with SQL Express : 1. What is your SQL Express computer's name? And what is its internal IP address? 2. Confirm that AyaNova was installed locally to this SQL Server as per step #2 of the networked AyaNova SQL Express steps http://www.ayanova.com/AyaNova4webHelp/network_sql_express_configurat.htm 3. Are you using the latest version of AyaNova - what version of AyaNova are you using? Log into AyaNova, select menu Help -> About AyaNova. 4. Make sure you are exited out of AyaNova program and that no other AyaNova related programs are running when you are attempting to do the AyaNova SQL database creation via the ToMSSQL utility (for example, if you had installed the network Generator make sure it is shut down in services; or if had installed the Data Portal that the Default Web Site and its AyaNovaDP site are shut down; or if installed one of the other programs, that they definitely are not running) 5. Confirm that SQL Express is also installed on this computer and that it is running as per step #3 in the SQL Express steps in http://www.ayanova.com/AyaNova4webHelp/network_sql_express_configurat.htm, and that the protocols identified are enabled, and that the Surface Area Configuration is set as it states. I know this may seem like a weird thing to check, but this was actually the issue with another AyaNova user who did not have SQL Express even installed on the computer. 6. Confirm the exact path where the AyaNova database file AYANOVA.FDB is localed on this server. As per the stand-alone installations stated to do in step #2 on this server, the AyaNova installation installs to the %AllUsersProfile%\AyaNovaData folder which is different depending on your OS - On a Vista computer, %AllUsersProfile% is usually C:\ProgramData\ whereas on 2000 or XP or 2003 computer, %AllUsersProfile% is usually C:\Documents and Settings\All Users\Application Data. Confirm exactly where the AYANOVA.FDB database file is on this SQL computer. 7. Enter in the Firebird database connection string: field and provide here exactly what you enter 8. Enter in the Microsoft SQL database connection string: and provide here exactly what you enter 9. Select the Open database connection. Does it precisely give you the message "Connections are good. You can now migrate data."? If not, be sure to provide the exact text it gives. Leave this open while you do the next step. 10. Open your SQL Express Management Studio, is there an AYANOVA database listed? If so, delete it (as if there is, this was the original database created, and we want to start fresh) 11. If you received the message "Connections are good. You can now migrate data." in 9 above, now click on the OK green checkmark in the ToMSSQL to start the AyaNova SQL Express database creation. This can take a few minutes to get going, and you will see the process bar % as it goes along. Is it now working? 12. If after more than 3 minutes it is still sitting at 1%, be sure to reply back to ALL of the above, as well as attach a copy of the ayalog.txt file from this computers AyaNova program folder. 13. If it is now working, do also post that too, as well as what it was that was now done that wasn't before if you can. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
Posted 9/10/2008 3:47:45 PM
