March 26, 2002 at 5:17 am
Hi,
We have a Linked Server on SQLServer 7 that connects to a Progress 91B database using the following Progress ODBC driver :
MERANT 3.60 32-BIT Progress SQL92 v9.1B
When we run a query from Query Analyser against a table in the Progress database, it picks up two Progress licences/connections.
The same query from either WinSQL or Excel only takes one. This is using the same DSN.
Any ideas ?
Thanks in advance
March 26, 2002 at 7:20 am
One may be for SQL admining the connection but I cannot find details on this. I will try to test against an Oracle machine here to see what happens. Also if something is blocking a connection to a linked server I read somewhere it will open another connection for tasks that enter and this could be the case of failure to close the first. Do the connections just stay open or do the timeout at some point?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 26, 2002 at 7:29 am
There is an initial connection, and then another connection is made before the first times out.
Once the results are returned, the second connection closes.
This is happening on development systems where there is no other activity other than the query I am conducting........
March 26, 2002 at 8:37 am
Interesting. Almost like a test connection before the other one sends the query. I'll try to take a look and see if this also happens in SQL.
Steve Jones
March 26, 2002 at 8:54 am
Have you tried throwing multiple queries at the same time to see if the connection doubles? Also try with another connection on a secound query fired at the same time. I do believe you will just see a second and third connection but not a forth like the first. I am pretty sure it is doing connection negotiation on the first.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply