.Net use pof ProxyGen classes to Progress and SQL Server thru AppServer. (916) Error

[maynardr]

Hi All

I am a .Net dev, but new to Progress.

I am trying to adjust an existing Stress test tool (written inhouse) to execute 4GL procedures against a Progress DB and a SQL server DB that was created with Dataserver (OpenEdge 10.2b). To compare and contrast the performance etc.

I have generated a Proxy dll OK, and defined an AppServer (Thru Progress Explorer) on port 3096. The Server startup parameters point to a .pf that just starts sports.db.
All works well, and I can call methods and get responses as expected.

However, I then created another AppServer on Port 3099, and set the startup parameters to a .pf file that points to sportssh (sports schema holder), and a ODBC connection to SQL Server.
The Proxy allows me to open the connection, instatiate the program object, but when I try to call the methods I get the following Exception:
"But connection to type PROGRESS was requested. (916) (7211)"

I have tried many variations on the AppServer, changing AppServer Name lists, Startup parameters etc, to to no avail.

The .pf file that I am using seems OK, when I click it it opens a Procedure Editor window, and I can load and run the Procedure .p files OK.

I set the AppServer logging to extended and get entries like the one below:
[10/07/23@13:18:04.145+0100] P-003284 T-006440 4 AS AS Server Message state = MSGSTATE_RECVLAST
[10/07/23@13:18:04.145+0100] P-003284 T-006440 3 AS AS requestID= <REQ|O4GL-000002>
[10/07/23@13:18:04.145+0100] P-003284 T-006440 4 AS AS -- TRACE: Open4GLWriteLast 898. (8401)
[10/07/23@13:18:04.145+0100] P-003284 T-006440 4 AS AS -- TRACE: Open4GLWrite 898. (8402)
[10/07/23@13:18:04.145+0100] P-003284 T-006440 4 AS AS -- TRACE: cso4GL: Before loadProc() (8458)
[10/07/23@13:18:04.145+0100] P-003284 T-006440 2 AS AS -- TRACE: Non-PERSISTENT Procedure 'OrderByCustomer.p' START. (5498)
[10/07/23@13:18:04.151+0100] P-003284 T-006440 4 AS AS -- TRACE: cso4GL: loadProc() failed. (8458)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 4 AS AS -- TRACE: Set open 4GL server state to 5. (8400)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 4 AS AS -- TRACE: cso4GL: setErrorState() calling csopenSetStop(). (8458)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 4 AS AS Server Message state = MSGSTATE_SENDRESP
[10/07/23@13:18:04.152+0100] P-003284 T-006440 4 AS AS -- TRACE: Set open 4GL server state to 1. (8400)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 1 AS -- OrderByCustomer.p Database sports has type MSS (869)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 1 AS -- But connection to type PROGRESS was requested. (916)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 4 AS AS -- TRACE: open4GLRead 81. (8403)
[10/07/23@13:18:04.152+0100] P-003284 T-006440 4 AS AS Server Message state = MSGSTATE_IDLE


The .pf for the Problem AppServer is :
-db sportssh -db sportsdsn -ld "sports" -dt MSS -U "dbo" -DataService mssbroker1 -Dsrv SVUB,1

sposrtssh is the Progress Schema Holder, sportsdsn is ODBC to SQl Server (2008) Sports database.
As I said, this .pf seems itself to work, just not thru proxy.


Has anyone tried to use one proxy to connect to both progressDB and Sql Server?, or seen this error (916) before?

I can Post a sample .Net app with C# source showing the problem, with the Sports database and Batch.p procedure if that would help.
With my two AppServer definitions.

Thanks

Ray