Web Wiz Forums - Universal Login Help

Print Page | Close Window

Universal Login Help

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7351
Printed Date: 04 April 2026 at 8:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Universal Login Help

Posted By: wistex
Subject: Universal Login Help
Date Posted: 17 November 2003 at 8:54pm

I am building a universal login for our site http://www.caribbeanchoice.com/ - 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.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Replies:

Posted By: WebWiz-Bruce
Date Posted: 18 November 2003 at 3:03am

You can have more than 1 connection to the database, but you are better combining them into 1 connection for better performance and less server overhead.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wistex
Date Posted: 18 November 2003 at 4:22am

I take it I am using the correct closing string.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: WebWiz-Bruce
Date Posted: 18 November 2003 at 6:32am

You are if those objects are being created.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: kmacy
Date Posted: 18 November 2003 at 9:36am

make sure you are also closing rsCommon, not just setting it to nothing.

rsCommon.close

-------------
Ken Macy

Posted By: wistex
Date Posted: 18 November 2003 at 8:09pm

I basically just added a modified version of the login items: