D
Darin
we have a VB application that we updated on a customer's machine. The
customer has SQL 2005 Express (they had MSDE and we had the same error
so we upgraded to express ohpeing that would fix the issue). THe
software runs fine from the server, but when trying to access it from a
client we get:
Timeout expired. The timeout period elapsed prior to obtaining a
connection from the pool. this may have occurred because all pooled
connections were in use and max pool size was reached.
In the application, we first try to connect to the SQL MASTER database
to make sure we can connect to the server, this is where the error is
occurring. The connection string is:
str = "Data Source=SERVER;"
str &= "Initial Catalog=MASTER;"
str &= "User Id={login}
str &= ";Password={password};"
str &= "Min Pool Size=1;"
str &= "Max Pool Size=50;"
str &= "Packet Size=32767;"
As you can see i have a pool size of 50 setup. Noone else is running the
software (since it errors out). Also, everything I have read says the
default timeout is 30 seconds, but this error appears in 15 seconds.
Also, in the program I have a try catch loop checking both
SQLClient.SQLException and general Exception, and this timeout message
is an Exception, NOT an SQL Exception.
Another interesting sidenote is if i chance the server name in the
connection string to a name that isn't on their network, I receive the
exact same timeout error. So, it isn't even getting to the SQL server at
all.
Our application uses .NET 2.0. The software worked fine on their setups
before yesterday, and that version was .NET 1.1.
Now, their IT guy came in and did some work on the internet router, and
i don't know exactly what he did, i am contacting him to find out.
This is critical as the customer is down.
Darin
customer has SQL 2005 Express (they had MSDE and we had the same error
so we upgraded to express ohpeing that would fix the issue). THe
software runs fine from the server, but when trying to access it from a
client we get:
Timeout expired. The timeout period elapsed prior to obtaining a
connection from the pool. this may have occurred because all pooled
connections were in use and max pool size was reached.
In the application, we first try to connect to the SQL MASTER database
to make sure we can connect to the server, this is where the error is
occurring. The connection string is:
str = "Data Source=SERVER;"
str &= "Initial Catalog=MASTER;"
str &= "User Id={login}
str &= ";Password={password};"
str &= "Min Pool Size=1;"
str &= "Max Pool Size=50;"
str &= "Packet Size=32767;"
As you can see i have a pool size of 50 setup. Noone else is running the
software (since it errors out). Also, everything I have read says the
default timeout is 30 seconds, but this error appears in 15 seconds.
Also, in the program I have a try catch loop checking both
SQLClient.SQLException and general Exception, and this timeout message
is an Exception, NOT an SQL Exception.
Another interesting sidenote is if i chance the server name in the
connection string to a name that isn't on their network, I receive the
exact same timeout error. So, it isn't even getting to the SQL server at
all.
Our application uses .NET 2.0. The software worked fine on their setups
before yesterday, and that version was .NET 1.1.
Now, their IT guy came in and did some work on the internet router, and
i don't know exactly what he did, i am contacting him to find out.
This is critical as the customer is down.
Darin