thanks nilesh
i have done the same ways it's running quiet well
i do have another prob
i want to establish a global connection throughout my application & for that
i have made a module & defined the connection there but it's not working
& in the operation i have to perform i have to exclusively establish the connection there if i don't do that it gives me the error saying
error no. "3709"
the connection cannot be used to perform the operation, either closed or invalid in the context