Microsoft KB Archive/922159

= Error message when you try to upgrade Groove Enterprise Management Server (EMS) 2.x to Groove EMS 3.X: “Line 1:Incorrect Syntax near &quot; =

Article ID: 922159

Article Last Modified on 7/6/2006

-

APPLIES TO


 * Groove Enterprise Management Server 3.0
 * Groove Enterprise Management Server 3.1

-



SYMPTOMS
When you try to upgrade Groove Enterprise Management Server (EMS) 2.x to Groove EMS 3.X, the upgrade fails. Additionally, you may receive the following error message:

[Microsoft][ODBC SQL ServerDriver][SQL Server]Line 1:Incorrect Syntax near ' '

Note Character is a placeholder for the specific noncompliant character or characters that are used.



CAUSE
This issue occurs when the Groove EMS 3.x database has a name that starts with a number (for example, &quot;1815upgrade&quot;).



RESOLUTION
To resolve this issue, make sure that the database name complies with the rules that are defined for identifier names in databases that use a compatibility level of 80. These rules are as follows:
 * The first character must be one of the following characters:
 * A letter that is defined by the Unicode Standard 2.0
 * One of the following symbols: _ @ #

Note The latter two symbols have special meanings when they are located at the start of an identifier.
 * Subsequent characters can be any of the following characters:
 * Letters that are defined by the Unicode Standard 2.0
 * Decimal numbers from either Basic Latin or other national scripts
 * The following symbols: $ _ @ #
 * The identifier must not be a Transact-SQL reserved word. Microsoft SQL Server reserves both the uppercase and lowercase versions of reserved words.
 * Embedded spaces or other special characters must not be included.

Additional query words: TCN-00502

Keywords: kbtshoot kbexpertiseinter KB922159

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.