I write in VB6.0 by use + SQL2008 C/S system, in the process of users found that network is normal, no packet loss, system connect to the database are often disconnected, connection timeout, disconnect from the database
1, the system automatically refresh function, there is a interval seconds will connect the database and then shut down the content of the data connection so cycle, most of the time will appear can't connect the database, application in a stuck state, Zhou Erfu death
2 in batch operation interface to save the input data, there will be a "general network error"
3, I also did PING server mechanism, if PING the server for the database connection, the card slowly broken but still happen
A lot of problems,,,,,,,,, slow, CARDS, are at the time of operation database
I would like to ask consult everybody a great god, can you talk about your experience? How to ensure that each data while doing C/S correct save and load databases, and the ability to quickly read it out? BuKa machine
Inability to read and write directly with the database directly? What good method?

CodePudding user response:

Don't shut down in the "automatic refresh" function code and the database connection, try to program on the database has been attached to, until the program exits and then disconnect

CodePudding user response:

Server connection number is a limit, to apply for the connection of too much will be refused, this is the most easy to out the cause of the "general network error",
How many client, you can calculate the total how many connections to each client, according to the maximum value calculation is beyond,
Set the SQL Server SQL maximum number of connections