OFFXPDEV: Cannot Save a Database as a Template Solution When the Database Has a Space in Its Name (290482)


The information in this article applies to:

  • Microsoft Office XP Developer
This article was previously published under Q290482

SYMPTOMS

When you try to create a template from a SQL Workflow application, you receive the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '<Character String>'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '.'.

CAUSE

You included a space in the name of the database from which you are trying to create the template. The SQL Server Workflow Template Creation Wizard cannot create a template from a database that has a space in its name.

RESOLUTION

Remove the space in the name of the database.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The problem described in the "Symptoms" section occurs only with SQL Server 2000 databases.

Steps to Reproduce the Behavior

  1. Click Start, and then click Workflow Manager for SQL Server.
  2. Click Create Template to open the SQL Server Workflow Template Creation Wizard.
  3. Click Next, and then click Connect to populate the Applications available on this server list box that has the names of the local SQL Workflow applications.
  4. Select the application with the space in its name.
  5. Click Next until you reach the Select Implementations Options page, and then click to select the Save to File check box.
  6. Click Next, and then click Finish to create the template.

    Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:8/9/2001
Keywords:kbbug kberrmsg KB290482
©2002 Microsoft Corporation. All rights reserved.