I am building a universal login for our site CaribbeanChoice.com and want to make sure that I am doing this right.
I have included common.asp as an include on all pages where I placed the Universal Login.
Am I correct that I have to include the following code somewhere at the bottom of the page?
<%
'Clean up
Set rsCommon = Nothing
adoCon.Close
Set adoCon = Nothing
%>
I have created a common-disconnect.asp file that contains this and included it at the bottom of all the pages that I included the common.asp include.
Is this correct? Is there anything else I need to include or need to know about?
Also, some other scripts use a different connection string, and that is also included as an include at the beginning of the page. I haven't had any problems so far, but is it okay to have 2 connection strings on the same page to the same SQL database (but accessing different tables in the same SQL database)?
Thanks.