We have vb and sql server in our project. we are using ado for the database connection. we are having a middle tier dll component which takes care of the sql operations. in our sub main we are creating this connection object and we will be having a global connection throughout... is this efficient.. what problems are we likely to face.. the sql server is giving errors like insufficient memory to process query.. is this due to the global connection ??