Hello!
At the MS SQL Server I set up an ODBC Connection to access the openEdge 11.7 data base. The connection test runs fine.
In SSMS I created a linked server. I can use this linked server with a quite simple query when querying one table and having a join to another one. Works fine.
But when I add any other join, then the query isn't executed and I get an error:
OLE DB provider "MSDASQL" for linked server "DPW_DATA" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Broker rejects connection.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "DPW_DATA".
Completion time: 2022-03-16T16:57:24.4039486+01:00
So i looked at proenv at the OpenEdge server and I can see 5 SQL connections to be open in that moment...
Any idea what's going on here and how to resolve this problem?
At the MS SQL Server I set up an ODBC Connection to access the openEdge 11.7 data base. The connection test runs fine.
In SSMS I created a linked server. I can use this linked server with a quite simple query when querying one table and having a join to another one. Works fine.
But when I add any other join, then the query isn't executed and I get an error:
OLE DB provider "MSDASQL" for linked server "DPW_DATA" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Broker rejects connection.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "DPW_DATA".
Completion time: 2022-03-16T16:57:24.4039486+01:00
So i looked at proenv at the OpenEdge server and I can see 5 SQL connections to be open in that moment...
Any idea what's going on here and how to resolve this problem?