Kbase P137006: Error 10713 when creating a SQL View from Visual Studio 2005
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/11/2008 |
|
Status: Unverified
SYMPTOM(s):
Error 10713 when creating a SQL View from Visual Studio 2005
Syntax error at or about (statement excerpt). (10713)
Syntax error in SQL statement at or about '[PUB].[table_name]' (10713)
FACT(s) (Environment):
SQL statement from Visual Studio 2005 is: SELECT * FROM [PUB].[table_name]
Connecting Visual Studio 2005 via ODBC driver
OpenEdge 10.1x
Windows
CAUSE:
"[" and "]" are not valid characters in SQL-92
FIX:
This is not a Progress issue. Visual Studio is adding [ and ] to the table name and the ODBC does not recognize them.
Contact Microsoft or the provider of the SQL front end application.