easy one about SQL Server

[Mih_Flyer]

hello,,,

if i use access database with many clients in my app. and i have to insert or delete or update any data in the database i connect to the database and do whatever then i close the connection,, this was in access,, my question is,, should i do the same in SQL Server 2000?? i have about 5-8 clients will use the same database server,, should i connect to the database at the start of my app and close the connection in the end of it,, or should i do the same as access database,, i mean connect - do whatever - close at every time i have to something in the database????

please help...
thanx

[mxnmx]

I think you should connect to SQL only when required...

[nateobot]

Connect only when necessary. If they are not doing anything then there is no reason for them to be connected.