Article ID: 922159 - Last Review: July 6, 2006 - Revision: 1.0
Error message when you try to upgrade Groove Enterprise Management Server (EMS) 2.x to Groove EMS 3.X: “Line 1:Incorrect Syntax near <character>"
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: Note Character is a placeholder for the specific noncompliant character or characters that are used.
[Microsoft][ODBC SQL ServerDriver][SQL Server]Line 1:Incorrect Syntax near 'character'
CAUSE
This issue occurs when the Groove EMS 3.x database has a name that starts with a number (for example, "1815upgrade").
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.
Note: This article is from Microsoft Knowledage Base
How we have helped PC users like you
In the News: Read More In ...
Related problems posted by other users | |
| more... |