SQL Server Maximum Concurrent Connection
-
I'm using MSSQL Server 2000, the licensing mode is Perseat License mode with 5 Client Access Linceses (5 devices). As I know, there are maximum 5 concurrent connections to SQL Server depending on that lincesing information. To test my knowledge, I write the code below in an ASP page:
Dim gblDBConn1, _ gblDBConn2, _ gblDBConn3, _ gblDBConn4, gblDBConn5, _ gblDBConn6, _ Dim sCnn sCnn = "Provider=SQLOLEDB;Initial Catalog=mydb;Data Source=server;UID=sa; PWD=pwd;" Set gblDBConn1 = Server.CreateObject("ADODB.Connection") Set gblDBConn2 = Server.CreateObject("ADODB.Connection") Set gblDBConn3 = Server.CreateObject("ADODB.Connection") Set gblDBConn4 = Server.CreateObject("ADODB.Connection") Set gblDBConn5 = Server.CreateObject("ADODB.Connection") Set gblDBConn6 = Server.CreateObject("ADODB.Connection") gblDBConn1.ConnectionString = sCnn gblDBConn2.ConnectionString = sCnn gblDBConn3.ConnectionString = sCnn gblDBConn4.ConnectionString = sCnn gblDBConn5.ConnectionString = sCnn gblDBConn6.ConnectionString = sCnn gblDBConn1.Open gblDBConn2.Open gblDBConn3.Open gblDBConn4.Open gblDBConn5.Open gblDBConn6.OpenThe page works fine although it creates 6 concurrent connections. What happen? I think that the maximum concurrent connections is 5 and the sixth will fail. I'm so confused. Please explain me! Thank you for any help. -
I'm using MSSQL Server 2000, the licensing mode is Perseat License mode with 5 Client Access Linceses (5 devices). As I know, there are maximum 5 concurrent connections to SQL Server depending on that lincesing information. To test my knowledge, I write the code below in an ASP page:
Dim gblDBConn1, _ gblDBConn2, _ gblDBConn3, _ gblDBConn4, gblDBConn5, _ gblDBConn6, _ Dim sCnn sCnn = "Provider=SQLOLEDB;Initial Catalog=mydb;Data Source=server;UID=sa; PWD=pwd;" Set gblDBConn1 = Server.CreateObject("ADODB.Connection") Set gblDBConn2 = Server.CreateObject("ADODB.Connection") Set gblDBConn3 = Server.CreateObject("ADODB.Connection") Set gblDBConn4 = Server.CreateObject("ADODB.Connection") Set gblDBConn5 = Server.CreateObject("ADODB.Connection") Set gblDBConn6 = Server.CreateObject("ADODB.Connection") gblDBConn1.ConnectionString = sCnn gblDBConn2.ConnectionString = sCnn gblDBConn3.ConnectionString = sCnn gblDBConn4.ConnectionString = sCnn gblDBConn5.ConnectionString = sCnn gblDBConn6.ConnectionString = sCnn gblDBConn1.Open gblDBConn2.Open gblDBConn3.Open gblDBConn4.Open gblDBConn5.Open gblDBConn6.OpenThe page works fine although it creates 6 concurrent connections. What happen? I think that the maximum concurrent connections is 5 and the sixth will fail. I'm so confused. Please explain me! Thank you for any help.TPN, It looks like you have 6 concurrent ADO Sessions through ASP, however, you only have one client session (TCP Session) or (Named Pipes). if you have 5 concurrent connections via machines with IP Addresses I'm sure that SQL will throw an error in the log stating that you have maxed out your connections. Tony
-
TPN, It looks like you have 6 concurrent ADO Sessions through ASP, however, you only have one client session (TCP Session) or (Named Pipes). if you have 5 concurrent connections via machines with IP Addresses I'm sure that SQL will throw an error in the log stating that you have maxed out your connections. Tony