I want to implement 3 tier MULTI USER application in visual basic(Client/Dll/Db) . I want to implement windows Authentication
with sqlserver2000 as Database
Connection string is :
dim strsql as string="Provider=sqloledb;database=Test;server=computer1;Trusted_connection=True"
How should the connection object be written in the middleLayer.
Lets say I have several functions in my DLL's which interact with the database.
Should I design in such a way that in each and every function open database serve data to the client
and close it Or should i go for global connection .......
Could it be explained in detail which technique to follow and why with a simple example
Thanks in advance