data source name

Part of the TechTarget Network of Enterprise IT Web Sites
Home Look It Up ITKnowledge Exchange Fast References Products White Papers Blogs

Search our IT-specific encyclopedia for:
 
OR Jump to a topic:
 
Advanced Search
Browse alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
All Categories Software Applications

data source name

(DSN also stands for Deep Space Network .)

A data source name (DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it. Included in the DSN, which resides either in the registry or as a separate text file, is information such as the name, directory and driver of the database, and, depending on the type of DSN, the ID and password of the user. The developer creates a separate DSN for each database. To connect to a particular database, the developer specifies its DSN within a program. In contrast, DSN-less connections require that all the necessary information be specified within the program.

There are three kinds of DSN: user DSNs (sometimes called machine DSN s); system DSN s; and file DSN s. User and system DSNs are specific to a particular computer, and store DSN information in the registry. A user DSN allows database access for a single user on a single computer, and a system DSN for any user of a particular computer. A file DSN contains the relevant information within a text file with a .DSN file extension, and can be shared by users of different computers who have the same drivers installed.





Read more about it at:
> SearchVB.com offers a collection of "Best Web Links for Database Programming."
> 4 Guys from Rolla decide between "System DSN or DSNless Connection."
This word suggested by: Beth Kane
Last updated on: Aug 20, 2005

>  Enterprise Software related Research & News
>  White Papers for the Retail Industry

Are you a Know-IT-All?
The word pixel was created from two other words. What does pixel stand for?
 Answer

WORD OF THE DAY...
nonrepudiation
LEARN MORE ABOUT...
What IT jobs pay the most?
Buzzword Alert: Chrome
Our Favorite Cheat Sheets
Our Latest Discovery
57 technology-specific sites
WhatIs.com RSS Feeds
Home Look It Up ITKnowledge Exchange Fast References Products White Papers Blogs
About Us   |   Contact Us   |   For Advertisers   |   For Business Partners   |   Reprints   |   RSS   |   Awards
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts