- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
- 25.1.3 Connector/ODBC Configuration
- 25.1.3.1 Data Source Names
- 25.1.3.2 Configuring a Connector/ODBC DSN on Windows
- 25.1.3.3 Configuring a Connector/ODBC DSN on Mac OS X
- 25.1.3.4 Configuring a Connector/ODBC DSN on Unix
- 25.1.3.5 Connector/ODBC Connection Parameters
- 25.1.3.6 Connecting Without a Predefined DSN
- 25.1.3.7 ODBC Connection Pooling
- 25.1.3.8 Getting an ODBC Trace File
A Data Source Name associates the configuration parameters for communicating with a specific database. Generally a DSN consists of the following parameters:
- Name
- Hostname
- Database Name
- Login
- Password
In addition, different ODBC drivers, including Connector/ODBC, may accept additional driver-specific options and parameters.
There are three types of DSN:
A System DSN is a global DSN definition that is available to any user and application on a particular system. A System DSN can normally only be configured by a systems administrator, or by a user who has specific permissions that let them create System DSNs.
A User DSN is specific to an individual user, and can be used to store database connectivity information that the user regularly uses.
A File DSN uses a simple file to define the DSN configuration. File DSNs can be shared between users and machines and are therefore more practical when installing or deploying DSN information as part of an application across many machines.
DSN information is stored in different locations depending on your platform and environment.
Ésta es una traducción del manual de referencia de MySQL, que puede encontrarse en dev.mysql.com. El manual de referencia original de MySQL está escrito en inglés, y esta traducción no necesariamente está tan actualizada como la versión original. Para cualquier sugerencia sobre la traducción y para señalar errores de cualquier tipo, no dude en dirigirse a mysql-es@vespito.com.
