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...
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...