Microsoft KB Archive/290482

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

Article ID: 290482

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Office XP Developer Edition

-



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 ''.

[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 &quot;Symptoms&quot; 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 &quot;Symptoms&quot; section of this article.

Additional query words: pra can't unable can not

Keywords: kbbug kberrmsg kbnofix KB290482

-

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

© Microsoft Corporation. All rights reserved.