Dr_Dre_247
New Member
We connect to a progress 9.1e database using Datadirect 4.10 32 bits SQL 92 v9.1e driver. The connections are split into 4GL and SQL servertypes. we connect to 2 databases. 1 database uses READ UNCOMMITTED setting, is only read from. The other is set to READ COMMITTED, since the process communicating to the database is updating it as well and we got errors in our application when we used READ UNCOMMITTED. What we see now is that on that specific SQL process the number of users connected is double the amount of users.
We see in the R&D, option 1, 3 on the server the number of connections (counted 14) and on the user overview we see only 7 users connected to server number 4 (which is the -ServerType SQL process). Any idea why this is happening? Any help appriciated where to get more detail on the processes on that SQL server process? There may be an easy solution to increase the possible number of users on the database, but we would rather find out what is causing this in the first place. The strangest thing is that on the other database we only see 3 users and that is the correct user count.
We see in the R&D, option 1, 3 on the server the number of connections (counted 14) and on the user overview we see only 7 users connected to server number 4 (which is the -ServerType SQL process). Any idea why this is happening? Any help appriciated where to get more detail on the processes on that SQL server process? There may be an easy solution to increase the possible number of users on the database, but we would rather find out what is causing this in the first place. The strangest thing is that on the other database we only see 3 users and that is the correct user count.
