Creating a DSN
page 1 of 2
Published: 01 Jul 2002
Unedited - Community Contributed
Abstract
This tutorial will instruct you on how to create a simple DSN connection to an Access database, but the same concepts apply for connecting to any other database through a DSN connection.
by . .
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 25492/ 36
Article Contents:

Introduction

Creating a DSN

Introduction

This tutorial will instruct you on how to create a simple DSN connection to an Access database, but the same concepts apply for connecting to any other database through a DSN connection.

Database...Check!

You obviously need a database.  It's good practice that you don't use any spaces in the names of columns or tables.  In Access, they allow you to do this, and when you access the data in a web page, it gets a bit messy. Put the database in any folder--the good thing about DSN's is that you can store the database on a completely different location than the web server, and this allows for added security if you're storing things like passwords or credit card details.


View Entire Article

User Comments

Title: Dsn   
Name: sreevalsan
Date: 2005-05-13 10:43:12 AM
Comment:
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
Comment:
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-2017 ASPAlliance.com  |  Page Processed at 2017-04-25 8:17:59 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search