Kbase P56298: Table/view/synonym not found (7519) when doing an Export in SQL Server using DTS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2009 |
|
Status: Verified
SYMPTOM(s):
Table/view/synonym not found (7519)
Error when trying to select for an Export
Using Microsoft SQL Server
Using DTS to link to Progress and retrieve records
Invalid object name, tagh received when executing query in a SQL query tool
SELECT "TAGH"."TAG_NBR", "TAGH"."TRAN_DATE" .... FROM "TAGH" WHERE "TAGH"."WCTR_NBR" = HROL
WCTR_NBR is a character field
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
Microsoft SQL Server is not recognizing that the table is in an external data source reached via ODBC and is generating invalid SQL statements
FIX:
Contact Microsoft Technical Support.
This is not a Progress problem as we have absolutely no control over how SQL Server generates its SQL statements