[b][red]This message was edited by f00sion at 2003-5-23 9:41:22[/red][/b][hr]
I am working on a pretty big app that is constantly doing different database tasks. Would it be better to have 1 adodb connection for the entire application to use or to create and destroy a connection in each time and function that it is needed? I do most programming in asp so I am very used to creating the connections and closing them right away if they aren't needed... maybe a bad habbit for use in visual basic? Any suggestions?
Also, I am currently using dsn-less connections, any advantages or disadvantages to that over using a dsn?
This is accessing a sql2000 database btw.