Sonic Fax - A division of Sonic Network (Pty) Ltd Home - Fax to Email
Main Page - Sonic Host About - Sonic Host Sonic Host - Services Sonic Host - Solutions Contact - Sonic Host  
Website Hosting
Client Login
Domain Registration
Sign Up for Website Hosting
 
  Scripting Support
- Coldfusion Hosting
- ASP Hosting
- PHP Hosting
- Perl Hosting
- ASP.Net Hosting
- ASP.Net v2 Hosting

Databasing Support
- Microsoft Access / ODBC
- MySQL Hosting
- Microsoft SQL Server 2000
- Microsoft Sql Server 2005
- Web Data Administrator
- Microsoft Query Analyser
- Microsoft Enterprise Manager
 
 

DSN Connections

DSN Connections Website Hosting

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 DSNs); system DSNs; and file DSNs. 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.



 
Copyright Sonic Network (Pty) Ltd | Sonic Network | Sonic Host | Sonic Fax | Sonic Mobile