Configuring Data Sources
Go Up to Configuring and Using ODBC Data Sources
Below are the steps for configuring a data source:
- Select
Start | Settings | Control Panel
and double-click the ODBC entry. (If you have the ODBC SDK installed, you can run the “32bit ODBC Administrator” utility instead). The “ODBC Data Source Administrator” window opens. - On the
User DSN
tab, click Add. The “Create New Data Source” window opens. - Select the InterBase ODBC driver and click Finish. The “InterBase ODBC Configuration” window opens.
- Enter the following information:
Data Source Name Make up a name for your data source Description
A description of the data course (not required)
Network Protocol
Choose the protocol from the drop-down list
Database
Full physical path to the database, including the database name
Server
Server name; if you choose the protocol “local,” this will default to the local server
Username
Your database user name, or SYSDBA
Password
The database password corresponding to the Username
- Optionally, click Advanced and fill in CharacterSet and Roles information.
- Click OK to return to the “ODBC Data Source Administrator” window. You should see the data source you just added, listed under User Data Sources.