Kbase P130180: Incorrect syntax error 37000 Using 9.1E Data Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/7/2008 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
Progress 9.1E
Windows
SYMPTOM(s):
Incorrect syntax error using 9.1E data server
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '1'.
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Using Microsoft SQL server driver
MS SQL server 2005 Database
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
User discovered the default database is not selected for the customer.
Rebuild schema holder using the DSN with default database selected as the customer database