Getting frequent errors from SQL Server 2016 while connecting to progress database using openedge driver

Sayanil Datta

New Member
Getting frequent errors from SQL Server 2016 while connecting to progress database using openedge driver:

1)An error occurred while preparing the query "Select * from XXXX where XXX.XXXXX='XXXXXXX'" for execution against OLE DB provider "MSDASQL" for linked server "ProgressDB".
2)Cannot execute the query "Select * from XXXXX where XXXX='XXXX'" against OLE DB provider "MSDASQL" for linked server "ProgressDB".
 

RealHeavyDude

Well-Known Member
Which version of Progress/OpenEdge you are using?
Do you get any Progress errror message number?
 

Sayanil Datta

New Member
In Progress we didn't get any error in the logs.

We are using Open Edge SQL Client 10.2b to connect to Progress database
 

Cringer

ProgressTalk.com Moderator
Staff member
It's possible it's to do with the table/field names as Progress allows you to use names that are invalid in SQL. You can get around this with quotes, but to definitively tell you that's the issue you'll need to post some errors without the XXX.
If that's not the issue, it could be to do with SQL widths on the Progress DB. But I'd expect the error to be a little different for that.
What version of Progress is running on the DB server?
 

Sayanil Datta

New Member
01000] (Message 0) The OLE DB provider "MSDASQL" for linked server "ProgressDB" reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ProgressDB". [SQLSTATE 42000] (Error 7303). NOTE: The step was retried the requested number of times (10) without succeeding. The step failed.

This is one of the error.


We got this error inside sql jobs when trying to connect to progress db via open queries
 

Sayanil Datta

New Member
An error occurred while preparing the query "Select * from PUB.A where PUB.A.A_domain='abc'"
The OLE DB provider "MSDASQL" for linked server "ProgressDB" reported an error. The provider did not give enough information.

Cannot execute the query "Select * from PUB.A where PUB.A.A_domain='abc'
The OLE DB provider "MSDASQL" for linked server "ProgressDB" reported an error. The provider did not give enough information.

This is the other error.
 

Sayanil Datta

New Member
Progress Database version is 2007
SQL Server version is 2016
OpenEdge driver version is 10.2B
 

RealHeavyDude

Well-Known Member
 

TomBascom

Curmudgeon
Faking error message content will only ensure that nobody can help you.

Without the real table and field names (I seriously doubt that "Select * from PUB.A where PUB.A.A_domain='abc' is real) we cannot tell you about likely syntax errors.
 
Top