Kbase P118018: Getting syntax error 7587 querying a Progress database through a linked MicroSoft 2005 SQL Server.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/08/2006 |
|
Status: Unverified
SYMPTOM(s):
Getting syntax error 7587 querying a Progress database through a linked MicroSoft 2005 SQL Server.
CAUSE:
There are differences in the permissible SQL statements made from Transact SQL in MicroSoft. Try altering the construction of the SQL statement being submitted.
FIX:
Example:
The following query is successful:
select * from openquery([LINKEDSERVERNAME], 'select * from pub.mytable')
The following queries although syntactically correct for Transact SQL will yield an error since these queries aren't recognize by the Progress SQL92:
select * from [LINKEDSERVERNAME].[DBNAME].[PUB].[mytable];
select * from [LINKEDSERVERNAME]..[PUB].[mytable];
select * from openquery([LINKEDSERVERNAME], 'select * from [pub].[mytable]')