Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Universal Login Help
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Universal Login Help

 Post Reply Post Reply
Author
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Topic: Universal Login Help
    Posted: 17 November 2003 at 8:54pm

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.

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Posted: 18 November 2003 at 4:22am
I take it I am using the correct closing string.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 18 November 2003 at 6:32am
You are if those objects are being created.
Back to Top
kmacy View Drop Down
Groupie
Groupie
Avatar

Joined: 15 March 2002
Location: United States
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote kmacy Quote  Post ReplyReply Direct Link To This Post Posted: 18 November 2003 at 9:36am

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

rsCommon.close

Ken Macy
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Posted: 18 November 2003 at 8:09pm

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

Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
ReadPrivate Messenger  Member Control Panel MenuSettings  LogoutLogout [wistex]

to every page of our website.

I wasn't sure what to close.  Thanks.

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.