I have 3-4 VB2005.NET applications in beta testing where I use SQL Express as my database. One of those applications has 4-5 steady users on a MS Small Business server where the SQL Express is installed.
I have ONE connection string I use for all users as shown below where MYID & MYPASSWORD are replace with a user id & password I have embedded:
connectionString = SQLLocationString & "\SQLEXPRESS;Initial Catalog=" & glDBString & ";Connection Timeout=360;User ID=MYID;Password=MYPASSWORD;"
I get this transport-level error sporatically from some of the users:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I'm wondering if it has to do with my users leaving the application open for any length of time and then attempting to perform a function thereafter. I don't think it occurs if they continue to use it because of the jpg image my errorhandler emails me when they get an error.
Is my way of logging in with a single ID & Password improper? Or should I be accounting for something else in my code to eliminate the possibility of this occuring.