[+/-]
The ODBC Data Source Administrator within
Windows enables you to create DSNs, check driver installation
and configure ODBC systems such as tracing (used for debugging)
and connection pooling.
Different editions and versions of Windows store the
ODBC Data Source Administrator in different
locations depending on the version of Windows that you are
using.
To open the ODBC Data Source Administrator in
Windows Server 2003:
On the
Startmenu, chooseAdministrative Tools, and then clickData Sources (ODBC).
To open the ODBC Data Source Administrator in
Windows 2000 Server or Windows 2000 Professional:
On the
Startmenu, chooseSettings, and then clickControl Panel.In
Control Panel, clickAdministrative Tools.In
Administrative Tools, clickData Sources (ODBC).
To open the ODBC Data Source Administrator on
Windows XP:
On the
Startmenu, clickControl Panel.In the
Control Panelwhen inCategory ViewclickPerformance and Maintenanceand then clickAdministrative Tools.. If you are viewing theControl PanelinClassic View, clickAdministrative Tools.In
Administrative Tools, clickData Sources (ODBC).
Irrespective of your Windows version, you should be presented
the ODBC Data Source Administrator window:
Within Windows XP, you can add the Administrative
Tools folder to your menu
to make it easier to locate the ODBC Data Source Administrator.
To do this:
Right click on the menu.
Select
Properties.Click .
Select the tab.
Within
Start menu items, within theSystem Administrative Toolssection, selectDisplay on the All Programs menu.
Within both Windows Server 2003 and Windows XP you may want to
permanently add the ODBC Data Source
Administrator to your
menu. To do this, locate the Data Sources
(ODBC) icon using the methods shown, then right-click
on the icon and then choose .
To add and configure a new Connector/ODBC data source on
Windows, use the ODBC Data Source
Administrator:
Open the
ODBC Data Source Administrator.To create a System DSN (which will be available to all users) , select the
System DSNtab. To create a User DSN, which will be unique only to the current user, click the button.-
You will need to select the ODBC driver for this DSN.
Select
MySQL ODBC 3.51 Driver, then clickFinish. -
You now need to configure the specific fields for the DSN you are creating through the
Add Data Source Namedialog.
In the
Data Source Namebox, enter the name of the data source you want to access. It can be any valid name that you choose. In the
Descriptionbox, enter some text to help identify the connection.In the
Serverfield, enter the name of the MySQL server host that you want to access. By default, it islocalhost.In the
Userfield, enter the user name to use for this connection.In the
Passwordfield, enter the corresponding password for this connection.The
Databasepopup should automatically populate with the list of databases that the user has permissions to access.Click to save the DSN.
A completed DSN configuration may look like this:
You can verify the connection using the parameters you have
entered by clicking the button. If
the connection could be made successfully, you will be
notified with a Success; connection was
made! dialog.
If the connection failed, you can obtain more information on the test and why it may have failed by clicking the button to show additional error messages.
You can configure a number of options for a specific DSN by using either the or tabs in the DSN configuration dialog.
The dialog can be seen below.
The three options you can configure are:
Portsets the TCP/IP port number to use when communicating with MySQL. Communication with MySQL uses port 3306 by default. If your server is configured to use a different TCP/IP port, you must specify that port number here.Socketsets the name or location of a specific socket or Windows pipe to use when communicating with MySQL.Initial Statementdefines an SQL statement that will be executed when the connection to MySQL is opened. You can use this to set MySQL options for your connection, such as setting the default character set or database to use during your connection.
The tab enables you to configure Connector/ODBC connection parameters. Refer to Sección 25.1.3.5, “Connector/ODBC Connection Parameters”, for information about the meaning of these options.
This section answers Connector/ODBC connection-related questions.
-
While configuring a Connector/ODBC DSN, a
Could Not Load Translator or Setup Libraryerror occursFor more information, refer to MS KnowledgeBase Article(Q260558). Also, make sure you have the latest valid
ctl3d32.dllin your system directory. -
On Windows, the default
myodbc3.dllis compiled for optimal performance. If you want to debug Connector/ODBC 3.51 (for example, to enable tracing), you should instead usemyodbc3d.dll. To install this file, copymyodbc3d.dllover the installedmyodbc3.dllfile. Make sure to revert back to the release version of the driver DLL once you are done with the debugging because the debug version may cause performance issues. Note that themyodbc3d.dllisn't included in Connector/ODBC 3.51.07 through 3.51.11. If you are using one of these versions, you should copy that DLL from a previous version (for example, 3.51.06).For MyODBC 2.50,
myodbc.dllandmyodbcd.dllare used instead.
É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.
