danieldunn10
New Member
Hi, I have successfully created in SQL Server Express a linked server to a Progress Database.
From the Linked Server I have created a view.
The problem I have found is that if I look at the view too many times there are too many connections and it throws this error:
OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Broker rejects connection.".
OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.".
Is there a way to close the connection to the linked server so i dont have too many open connections?
Many Thanks
From the Linked Server I have created a view.
The problem I have found is that if I look at the view too many times there are too many connections and it throws this error:
OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Broker rejects connection.".
OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.".
Is there a way to close the connection to the linked server so i dont have too many open connections?
Many Thanks