Kbase P8056: Airborne's Libra Data Connect software (SQL connections)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/17/2006 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
Progress 8.3X
SYMPTOM(s):
SQL-89 connections to database
MERANT][ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "DECLARE". (247)
[MERANT][ODBC PROGRESS driver][PROGRESS]** Invalid statement. (254)
CHANGE:
Moved to Airborne's Libra Data Connect software. Previously used UPS Worldship without any problems
CAUSE:
AirBorne's SQL query uses field aliases, which is not available in the Progress SQL-89 (Progress 9.X supports field aliases).
FIX:
Upgrade to 9.X