Dan Sullivan
New Member
I have an old small VB6 app that I am trying to update to VB..NET 2010. Still learning the .NET coding changes. I am getting an odd "broker rejects connection" in the middle of a repetitive process. Essentially, it is a small data gathering app. I am collecting data on students to port into another application. I grab one recordset and page through it and to populate certain fields I have to run another query with some logic.
The odd thing is the second query works fine for the first 120 or so calls then when it gets to student 123 and makes the call to the second function, the SQL call to the database gets the "broker rejects connection" error.
One more wrinkle, this does not happen on my local machine. But I need to run the app remotely on a virtual copy of my local machine. The error only occurs on the remote machine.
My hunch is there is some obscure setting that is limiting the number of sql statements that can be run, but I have no idea where to look. We use the Progress OpenEdge 10.2B driver, Windows 7.
The odd thing is the second query works fine for the first 120 or so calls then when it gets to student 123 and makes the call to the second function, the SQL call to the database gets the "broker rejects connection" error.
One more wrinkle, this does not happen on my local machine. But I need to run the app remotely on a virtual copy of my local machine. The error only occurs on the remote machine.
My hunch is there is some obscure setting that is limiting the number of sql statements that can be run, but I have no idea where to look. We use the Progress OpenEdge 10.2B driver, Windows 7.