Web Wiz Forums - Using DSN

Print Page | Close Window

Using DSN

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=688
Printed Date: 30 March 2026 at 9:38am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Using DSN

Posted By: Deen
Subject: Using DSN
Date 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.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 March 2003 at 3:08pm

Sorry the SQL server version doesn't work with a DSN connection to the database.

-------------
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: Deen
Date 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.

Posted By: hockenpj
Date 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.

Posted By: Deen
Date Posted: 04 March 2003 at 9:42am

Tell me which is good and fast using DSN or DSN less connection to connect the databse

Posted By: WebWiz-Bruce
Date 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.

-------------
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: Deen
Date 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.

Posted By: TimDaugherty
Date 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

Posted By: boyohboy
Date Posted: 01 April 2003 at 11:57am

hi borg

Does THIS forum run on MS SQL?

-------------
Visit my community website @
http://www.everythingviet.com - EverythingVIET.com

Posted By: Deen
Date Posted: 01 April 2003 at 12:14pm

Hi, I am okay with DSN connection and working well now, and I dont get any errors still now, and comparing to the speed in process I dont see any difference.