Database Discussion - dsn to dsnless

Print Page | Close Window

dsn to dsnless

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7675
Printed Date: 28 March 2026 at 4:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: dsn to dsnless

Posted By: biscayne
Subject: dsn to dsnless
Date Posted: 28 November 2003 at 6:01am

I run an app with a DSN connection. Since the DB is growing quickly I was thinking that switching to DNSless might be a good idea. The app has at least 25 ASP pages with code such as "rs.Open q, "DSN=web1.file"". Am I looking at a nightmare project here?

Replies:

Posted By: ljamal
Date Posted: 28 November 2003 at 8:17am

Not really a nightmare if you have a text editor capable of search and replace on closed documents.

My suggestion would be to place such information into a variable in an include file so you only have to replace it once.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming