How to Create an ODBC Datasource
To connect to SQL Server tables you will need an ODBC datasource.
Step 1: Start
In the Select Data Source dialog click on the New... button.
Step 2: Select driver
The select driver list box appears. Select SQL Sever and Click the Next > button.
Step 3: Enter a name
Type a name for the datasource file and Click the Next > button.
Step 4: Finish
Click Finish to create the datasource.
Step 5: Enter server name or IP address
Create datasource for SQL wizard opens. Enter a description for the datasource. Enter the name or IP address of the server the SQL Server database is on. For a database on the same computer database enter "(local)". Click the Next > button.
Step 6: Enter login information
In the authentication dialog select "With SQL Server authentication." option. Enter the Login ID and Password for the SQL server database. Click the Next > button.
Step 7: Enter a data source name
Check the Change default database to checkbox. Select the database name from the dropdown list. Click the Next > button.
Step 8: Finish
Click the Finish button.
Step 9: Test connection
The ODBC Microsoft SQL Server Setup Test page appears. Click on the Test Data Source... button. If the data source was set up correctly, you will see the TESTS COMPLETED SUCCESSFULLY! message.
Step 10: Complete
Click the OK button. Click the OK button on the Test page also. The new data source will now apppear in the Select Data Source dialog.
Step 11: New data source
The new data source will now appear in the Select Data Source dialog. You are ready to link tables now.