thanks eric !!
i got the setup1.vbp and i'll try visual studio installer for dsn creation.
Now another query
1. in normal scenario how many connections could be handled by ADO using sql server or to be more specific how many requests can be handled by one single VB connection.
2. i was just wondring how to handle the locking mechanism using ADO and sql server when my application is being used by over 100 user symaltaneously ? can u plz brief the best practise !!

thanks again !