[+/-]
The ODBC Data Source Administrator within
Windows lets you 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:
To identify whether a DSN was created using the 32-bit or the
64-bit driver, include the driver being used within the DSN
identifier. This will help you to identify the right DSN to
use with applications such as Excel that are only compatible
with the 32-bit driver. For example, you might add
Using32bitCODBC to the DSN identifier for
the 32-bit interface and Using64bitCODBC
for those using the 64-bit Connector/ODBC driver.
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 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, consider
permanently adding 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 .
The interfaces for the 3.51 and 5.x versions of the Connector/ODBC driver are different, although the fields and information that you need to enter remain the same.
To configure a DSN using Connector/ODBC 5.2, see Section 4.3.1, “Configuring a Connector/ODBC 5.x DSN on Windows”.
User Comments
The Advanced tab is not present in 5.1.
If you can't find the ODBC Data Sources in the menu and can't be bothered to enable the admin tools: just enter odbccp32.cpl on the commandline.
In Vista the command-line (Run) seems to be "ODBCAD32".
In Windows 7 Pro x64 with MS Access 2010 and MS Excel 2010, I had to use a Data Source Name (DSN) which did not have spaces in it. Otherwise I would receive the error: "Could not determine the driver name; could not lookup setup library.".
Additionally, I had to install the 32 bit ODBC Connector first, and then install the 64 bit ODBC Connector on top of the 32 bit Connector.
Add your own comment.