Creating a DSN
page 2 of 2
by . .
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 15988/ 55
Article Contents:

Creating the DSN


Now we get to the good stuff... I have provided some helpful screenshots to guide you on your DSN creation.

Go into Control Panel:

Then Administrative Tools:

Then ODBC Data Sources:

Then click on the System DSN tab and click on Add:

You see a bunch of tabs at the top these tabs are different things to do with ODBC. User DSN are DSN's for a specific user, but for a web server you shouldn't create DSNs in here; use them for internal pages for you only. System DSN:  the whole system can see these, and they are ones that everyone that accesses your computer can see.

Choose your driver:

Here you can choose any of the available database drivers on your machine.  Choose the one for accessing the type of database you will be using. If you are running SQL Server, here you choose the SQL Server Driver, and you have to supply server addresses, passwords, usernames, database names, etc.

Set up the DSN:

  1. Enter a Data Source Name; this is what we call your Database, so keep it short and without spaces. eg. myBooks
  2. Click on Select... to browse to the directory where your database is and choose it.  This tells ODBC where to find the DB.
  3. If you set a password for your database, click on Advanced....


Access only supports passwords, not usernames, so just enter the password and click OK.

Click OK to the other dialog and you can see your DSN listed in the System DSN list, and now you can use it to set up databases.

View Entire Article

User Comments

Title: Dsn   
Name: sreevalsan
Date: 2005-05-13 10:43:12 AM
How we call this dsn in codebehind
Title: how i connect sql server by using DSN with ADO.NET   
Name: sushil
Date: 2005-03-03 6:15:09 AM
how i connect sql server by using DSN with ADO.NET

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-05-18 10:36:52 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search