Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "progress"

Status
Not open for further replies.
D

Deise Vicentin

Guest
I'm trying to select some data from a Progress Database using an openquery on SQL Server 2008 R2, but I'm getting this error message.

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "progress" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "progress".


I did some tests and I discovered that the problem is with a specif column which is a varchar column. The column has around 30 columns and for them the select works fine. This is my query:

SELECT * from openquery(progress, 'select DescricaoProduto from MP.pub.IMPproduto')


I tried to do some different selects but none of them worked. For example:

SELECT * from openquery(progress, 'select Cast(DescricaoProduto as char(100)) as DescricaoProduto from MP.pub.IMPproduto')


Any idea about what to do?

Continue reading...
 
Status
Not open for further replies.
Top