Database handling across procedures

[Stevenn]

I have some modules which contains some procedures which uses a database connection through ADODB. What is the best way to control all these procedures database connections?

Can I somehow only write the username, password and such one time and then reuse this in the other modules?

 

[Trevor G]

create a separate sub routine and then you should be able to call the new routine in the other modules.

 

[Norie]

You can make the username, password etc public constants then they can be used across the modules.

As for the connection thing, I would control each procedures connections within the procedure, eg open and close the connection in the procedure.