by Bob Dombroski
Have you ever had the need to set up a new Database, but dont have the rights to set up a system DSN? You could set up a connection string in a application variable, but on any change you would need to cycle the server(and if you dont have rights to set up a system DSN, you probably wont have rights to cycle the server). How about setting up a file DSN? Its quick, painless and can be easily changed.Have you ever had the need to set up a new Database, but dont have the rights to set up a system DSN?
The best part of using a file dsn, you can create an entire new application on a local machine accessing a local database, then move it to a remote server and install the database right from your local machine without involving an administrator. This can save the developer valuable time.
The working examples of my articles on hit counters and database based forms both use file DSN's for connecting to a database.