Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Using DSN
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Using DSN
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Deen View Drop Down
Newbie
Newbie
Avatar

Joined: 03 March 2003
Location: United States
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Deen Quote  Post ReplyReply Direct Link To This Post Topic: Using DSN
    Posted: 03 March 2003 at 1:39pm

Please let me know what changes and where should I make in the common.asp file if I need to Use a DSN to connect the MSSQL server. I am using the webwizforum_SQLserver7 version. I have changed the database name with a different DSN name.

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: 03 March 2003 at 3:08pm
Sorry the SQL server version doesn't work with a DSN connection to the database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Deen View Drop Down
Newbie
Newbie
Avatar

Joined: 03 March 2003
Location: United States
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Deen Quote  Post ReplyReply Direct Link To This Post Posted: 03 March 2003 at 3:41pm

Hi boRg
Please tell me what is the difference and advantage in using Access and msSQL database. Which is the fastest and convenient to handle. If in case I use the DSN less connection Where and what should I make the changes.
Back to Top
hockenpj View Drop Down
Groupie
Groupie
Avatar

Joined: 10 February 2003
Location: Belgium
Status: Offline
Points: 149 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hockenpj Quote  Post ReplyReply Direct Link To This Post Posted: 03 March 2003 at 5:44pm

SQL is more stable etc... (See the other discusions about SQL vs. Access)

You will find Access easier to use

You should make all changes regarding the database connection in the common.asp file.
Back to Top
Deen View Drop Down
Newbie
Newbie
Avatar

Joined: 03 March 2003
Location: United States
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Deen Quote  Post ReplyReply Direct Link To This Post Posted: 04 March 2003 at 9:42am
Tell me which is good and fast using DSN or DSN less connection to connect the databse
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: 04 March 2003 at 9:58am
DSN-less connection is faster than the DSN, also the forum is designed for the DSN-less connection with the driver that is advised for it, you may find that the forum will not run at all and also slower with a DSN.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Deen View Drop Down
Newbie
Newbie
Avatar

Joined: 03 March 2003
Location: United States
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Deen Quote  Post ReplyReply Direct Link To This Post Posted: 04 March 2003 at 10:33am

Well, I tried using DSN not knowing that it want work, but how ever it works with a DSn connection but I dont know how fast it is. I will have to try by using DSN-less connection and compare the fast.

I have another question for you, tell me how can I display the number of visitors and number of active visitors as you can see at the bottom of this page.
Back to Top
TimDaugherty View Drop Down
Newbie
Newbie
Avatar

Joined: 01 April 2003
Location: United States
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote TimDaugherty Quote  Post ReplyReply Direct Link To This Post Posted: 01 April 2003 at 11:52am

I am using DSN as well. I can use the forum, but encounter problems when trying to administer it. Where all do I need to change the DSN code? Just in common.asp? When I click the link for the "Admin" at the top left as noted in the instructions, I get a page that comes up showing that I'm not authorized to view that page (like I'm not logged in as the Administrator.)

I have already set up the DSN with my host.

Any ideas? I can't use SQL due to cost ($25 U.S. added to my monthly account.)

 

Thanks
Back to Top
 Post Reply Post Reply Page  12>

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.