Web Wiz Forums - Using DSN for SQL 2000 Database version

Print Page | Close Window

Using DSN for SQL 2000 Database version

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=12259
Printed Date: 09 April 2026 at 8:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Using DSN for SQL 2000 Database version

Posted By: moti
Subject: Using DSN for SQL 2000 Database version
Date Posted: 20 October 2004 at 8:48pm

Hey

Can I use DSN for SQL Database version for forum?

for ex, strCon = "DSN=forum"

Which one is better

DSN or SQL OLE DB

Replies:

Posted By: WebWiz-Bruce
Date Posted: 21 October 2004 at 3:18am

Web Wiz Forums can not use a DSN with MS SQL Server.

Using a DSN-less connection is always faster than a DSN connection as less hits have to be made on the OS's registery.

-------------
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