PRB: Table Names Using Quoted Identifiers Do Not Open Properly (194010)
The information in this article applies to:
- Microsoft Visual InterDev 6.0
- Microsoft SQL Server, Enterprise Edition 6.5
This article was previously published under Q194010 SYMPTOMS
When you open, or design against, existing tables in the Visual InterDev
Data View, one of the following error occurs:
-Table 'tablename' no longer exists in the database.
-[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near 'tablename'.
-Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '<tablename with space>'.
/<project>/_ScriptLibrary/Recordset.ASP, line 466
CAUSE
This occurs when you attempt to view or open a table with a space in its
name in Design View, or if the "Use ANSI quoted identifiers" option is not
selected when you create the data connection to the database.
RESOLUTION
To avoid this problem, you can use one of the following workarounds:
- Delete the existing data connection from the project.
- Ensure that the option "Use ANSI quoted identifier" is selected in the
Add data connection wizard, and then add a new Data Connection to the
database.
- Recreate the table with a valid SQL Server name (no spaces).
STATUS
This behavior is by design.
Modification Type: | Minor | Last Reviewed: | 3/16/2005 |
---|
Keywords: | kbDSupport kberrmsg kbprb KB194010 |
---|
|