Thursday, November 15, 2007

Schema DB or User DB move error when destination DB is SQL2005


Schema Repository could not be created with SQL Server 2005


When move schema db and user db from SQL2000 to SQL2005, may meet error as below,

SQLExecDirect: RETCODE=-1, State=37000, Native Error=-3504 SQL statement='select from master_global' [Microsoft][ODBC Microsoft Access Driver]The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Here is the solution provided by IBM,
http://www-1.ibm.com/support/docview.wss?uid=swg21239777


No comments: