What are SQL or MSDE best practices for connections
Database
1
Posts
1
Posters
1
Views
1
Watching
-
My question relates to whether its better to maintain a connection to the SQL database and pass the the pointer to CRecordset when required or use a connectionless set-up (which seems to be the default) where you open the database during each CRecordset use? Doesn't maintaining the connection reduce overhead? Is there any documentation on the pros and cons? Rodney