hi guys, Thanks for your valuable help ..actually i didnot run the xpo files thats y i got the error ...now its over i imported the 2 xpo files and ran the form which was imported ...now it got updated...once again thanks guys.
Regards Rinish.N --- On Wed, 25/3/09, Jens Strandberg <[email protected]> wrote: From: Jens Strandberg <[email protected]> Subject: RE: [Axapta-Knowledge-Village] Error while upgrading To: [email protected] Date: Wednesday, 25 March, 2009, 12:55 PM Did you run the two scripts in the "original" database before trying to use AxDbUpgrade ? If not, the upgrade will fail, since it does not know about "UpgradeColumns" ... /Jens From: Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of nanukuttan rinish Sent: Tuesday, March 24, 2009 3:17 PM To: Axapta Subject: [Axapta-Knowledge- Village] Error while upgrading Hi All, I am trying to upgrade from Ax 3.0 to Ax2009.As a first step I was running the AxDbUpgrade. exe file..But while doing this I got the following errors. " SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState S0002, NativeError 208: [Microsoft][ ODBC SQL Server Driver][SQL Server]Invalid object name 'UpgradeColumns' . SqlState 37000, NativeError 8180: [Microsoft][ ODBC SQL Server Driver][SQL Server]Statement( s) could not be prepared. Cannot read the list of columns to be upgraded. " I am using win2003 server in both the computer where Ax3.0 and Ax2009 are installed. Both AX DataBase are in SQL2005, hosted in two different system inside the n/w and the DB names are AxDB3.0 and AXDB2009. I hope someone would have come across this problem and hoping that you would have fixed it .If so please let me know how to overcome this one ...please help me... Regards Rinish.N Add more friends to your messenger and enjoy! Invite them now. Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/

