Victor Hdz
New Member
Hello everybody in the forum!
It's my first post in this forum and I'm also new using progress too
I have a problem, any help will be gratefull, I have a connection between a Progress DataBase with a MS SQL Server 2008 R2 Database
I made an ODBC connection using ODBC Progress OpenEdge 10.2B driver and making a linkedserver in MS SQL to access my progress database
Everything works fine at the beginning, I made a couple of MS SQL views objects using openquery to go through ODBC and get data storage on progress but when I use more than one view in the same query, I get this error:
OLE DB provider "MSDASQL" for linked server "[LINKED_SERVER]" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server "[LINKED_SERVER]" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Broker rejects connection.".
OLE DB provider "MSDASQL" for linked server "[LINKED_SERVER]" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.".
seems like there is any kind of error about the number of connections made it via odbc, any idea to resolve this problem? I need to use a lot of views on my querys
thanks a lot!
It's my first post in this forum and I'm also new using progress too
I have a problem, any help will be gratefull, I have a connection between a Progress DataBase with a MS SQL Server 2008 R2 Database
I made an ODBC connection using ODBC Progress OpenEdge 10.2B driver and making a linkedserver in MS SQL to access my progress database
Everything works fine at the beginning, I made a couple of MS SQL views objects using openquery to go through ODBC and get data storage on progress but when I use more than one view in the same query, I get this error:
OLE DB provider "MSDASQL" for linked server "[LINKED_SERVER]" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server "[LINKED_SERVER]" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Broker rejects connection.".
OLE DB provider "MSDASQL" for linked server "[LINKED_SERVER]" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.".
seems like there is any kind of error about the number of connections made it via odbc, any idea to resolve this problem? I need to use a lot of views on my querys
thanks a lot!