-
Hello guys, To start off with the scenario where i am facing a problem ...
I validate a user and give him access to a particular server with a database.. [ we have multiple serv/dbs ].
In the form where i validate him i make a connection to the database and check for his permissions.. Here i am making a connection to the database..
Now i have many forms which amount upto 20+ where i am checking for some conditional statements by again connecting to the database..This process will be very slow..Since we have already made a connection to the database starting can i use the same connection across all my forms..Doing this will leave the burden of connecting each time to check some validtions....
GUYS i need to know if there is any way where i can use a single connection string which can serve me in all of my forms...
YOUR FEEDBACKS ARE REALLY APPRECIATED...THANX ! !
-
U don't have to connect each time to the server /Db. You can declare a Public connection object in a module so the connection object is available through out the program...
Hope this helps
