mm i think i dont understand let me explain you in the program code  when the form is load the program opens the connection, example:

form_load

conn="connectionstring"

conn.open

end sub

and then every process uses...

Oh ok i understand but what will happen if for example in the company there are like 2000 employees so they check in the time and attendance system at same...

ok let me see

i have 7 clocks for time and attendance system, 15 Pc using payroll and HR system and 1 pc using coffee shop system, every PC or...

yes, actually i saw that in the time and attendance system there's an open connection all days cause the system open a connection when starts and never close the connection...

Ok, i checked it out and in connections is unlimited but in query timeout is 600 the value this server supports 3 systems and 4 databases.