Class Module to wrap up classic ADO call to SQL-server
Suggestions:


Don't assume the cursor type of the recordset, the user might want a different type.
Consider making a ConnectionString class that lets the user use properties to get and let the individual parameters, but allows assigning or returning a complete string
Don't force the connection to close, as the user might intend to make subsequent calls.