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

#1
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".
 

Cringer

ProgressTalk.com Moderator
Staff member
#4
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?
 
#5
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
 
#6
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.
 
#9
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