Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 2, 2001

DSNGen - Another Tool For the Toolbox - Page 2

By Andy Warren

Select #3 - Select Type of DSN to Create

The default setting is to create a system DSN, the one most commonly used in my experience. Both system and user DSN's are registry based, while a File DSN is stored in the file system. Take a look at my article DSN's - What are they? for details about how DSN's work and the differences between them.



Step #4 - Options

There are two options here. The first is 'ServerName as Prefix'. Check this to give your DSN's more descriptive names. If the server name is SQLTest and the database name is Pubs, checking this box will create a DSN called SQLTest_Pubs. This is very handy if you have databases on different servers with the same names. It also makes picking the DSN easier later on as all the DSN's from each server will be grouped together.


The second option, 'Trusted Connection', is checked by default and indicates that the DSN will use NT security to connect. Uncheck this box if your users (or your application) uses SQL logins.



Step #5 - Generate the DSN's!

If you selected System or User as the DSN type, a file called DSN.REG will be created in the folder where DSNGen.exe is installed. It is NOT entered into the registry yet. If you chose to create a File DSN, then you will one *.DSN file per database in the DSNGen folder. Again, these are not copied to your default File DSN folder at this time. This allows you to review them before deploying, reducing concerns about changes made to your machine. Another good read for this is that in many cases you may be creating them on your machine for use n a different machine.



Step #6 - Deploy the DSN's

If you don't want to deploy the DSN's on your machine, just click 'I'll Deploy the DSN's Later'. You can then review the files before deploying.


If you selected System or User as the DSN type, clicking on 'Deploy DSN's Now' will use RegEdit to merge the DSN.REG file into the registry. If you created file DSN's, they will be copied to your system DSN folder (which is usually C:\Program Files\Common Files\ODBC\Data Sources).




Return to DSNGen Introduction       Proceed to Download Page

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM