Progress: ODBC Error When connection SQL Server OPENQuery

[dan.damico]

Our company is using the DataDirect OpenEdge ODBC driver 10.1B as a interface between Progress and SQL Server. A linked server was created in SQL Server to connect to the ODBC driver

The database developer had issued a query from SQL Server SELECT * FROM OPENQUERY(linked_sever, 'select * from pub.tb')

It was determined several days later that this query was hung by noting in SQL Server that the user had cancelled the query and the wait time was still growing. Upon review the _sqlsvr2.exe was hung. The only way to free it up was to kill that process and then bounce sql sever to free it up.

The following error were reported by the database developer.

OLE DB provider "MSDASQL" for linked server " prog_dbconn " returned
message "[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server " prog_dbconn " returned
message "[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver][OPENEDGE]Broker rejects connection.".
OLE DB provider "MSDASQL" for linked server " prog_dbconn " returned
message "[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver]Optional feature not implemented.".


The developer had mentioned something about the possibility that there may be data existing on the Progress database that is outside the the table/column specification. From what I understand Progress is not a strongly typed db so this can occur. I am wondering what the odds are that the ODBC driver is choking on data that falls outside of the schema definition trying to pull it out and return it to SQL Server

I am wondering if anyone has faced these error before and me able give some guidance.