Kbase P120234: SQL Query Analyzer gets error from linked Progress server: OLE DB provider 'MSDASQL' supplied inval
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/10/2007 |
|
Status: Verified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SQL Server 2000
Windows
SYMPTOM(s):
SQL Query Analyzer gets error from linked Progress server:
OLE DB provider 'MSDASQL' supplied invalid metadata for column
<column name>. The precision exceeded the allowable maximum.
DBTool validates that SQL widths of data are not exceeding defined SQL widths.
3rd Party ODBC / SQL tools successfully runs query.
Works correctly when interacting with SQL-89.
Fails when interacting with SQL-92.
CAUSE:
MicroSoft SQL Query may need to limit the size of data or temporarily convert data to a different datatype within MSSQL.
FIX:
Use the cast function of SQL to allow a different precision or shift to a different datatype.
Example:
cast(pub.customer.amount as decimal(12,2))
or
cast(pub.customer.amount as float)