Kbase P110435: Incorrect syntax error when used 9.1D DataServer broker with 9.1E client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2008 |
|
Status: Verified
SYMPTOM(s):
Incorrect syntax error when used 9.1D DataServer broker with 9.1E client
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '@P1'.
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
FACT(s) (Environment):
MS SQL DataServer
Progress 9.1D
Progress 9.1E
Windows NT 32 Intel/Windows 2000
The following SQL is parsed by the 9.1D DataServer:
SELECT PROGRESS_RECID, "state" FROM "sp2k"."dbo"."state" WHERE (("state" = ?
Two closing brackets are missing from the above SQL generated for the WHERE clause.
Error occurs only when there is WHERE clause in the query
CAUSE:
Bug# OE00123221
FIX:
There are three workarounds:
1. Use the same versions for both Microsoft SQL Server DataServer and the client.
Or
2. Do not use the DataServer broker. Or 3. If you need a broker and can not upgrade either server or client, use send-sql stored procedure directly executing the query on the server