Hi All,
As usual, nothing is straightforward upgrading from one major release to the next. Does anyone have any ideas about the following error messages:
Upgrade Tool
Log File Results:
Error running query in SpDbOdbc
State=37000
Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'sVault'.
========= LAST COMMAND ========
Declare @LogFile As VarChar(255);
Select @LogFile = name From sys.database_files Where type = 1;
EXEC('ALTER DATABASE [SWPDM_Mark'sVault] MODIFY FILE ( NAME = ' + @LogFile + ', MAXSIZE = UNLIMITED )' );
Server: (local)
Database: SWPDM_Mark'sVault
Looks like you're going to have to rename your vault. The apostrophe is breaking the SQL command.
Rename the database and then edit the registry to point to the correct database. I'd file a SR with your VAR.