Database Reference
In-Depth Information
Configuring the Data Source in Windows
You configure your Windows machine for ODBC in the Control Panel (Start→Control
Panel). Open the System and Security category and then click Administrative Tools. If you
don't have “System and Security,” look for Administrative Tools right in the Control Panel
window and then open it there.
Assuming you've found the Administrative Tools window, look inside it and then open Data
Sources (ODBC). You should see something on your screen that looks like
Figure 21-6
.
In this window, you add a
DSN (data source name)
for each SQL database you want
FileMaker to work with. A DSN can be one of two flavors: A
System
DSN is available to
everyone who uses your computer, and a
User
DSN is available only to the person who cre-
ated it. FileMaker works only with the System DSN variety, so to get started, switch to the
System DSN tab. Unfortunately, you may not have permission to define these computer-wide
data sources on your work computer. If Windows doesn't let you add a system DSN, then
contact your system administrator.
Once you're on the System DSN tab, click Add. Windows shows you a list of available
ODBC drivers. Select the appropriate one and then click Finish. (Don't get too excited by the
label on this button; you're nowhere near finished.)
