Figure

A success message on getting a connection to a SQL Server database.

SQL Server ODBC Data Source Test

X

-Test Results--

Microsoft SQL Server ODBC Driver Version 03.85.1117

Running connectivity tests...

Attempting connection

Connection established

Verifying option settings

Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

i 5 i

13. Click OK on the test message and then on the ODBC Microsoft SQL Server Setup screen, then click OK on the Select Data Source screen (Figure 18.61) with the newly created DSN selected.

FIGURE 18.61

Selecting the newly created DSN.

FIGURE 18.61

Selecting the newly created DSN.

14. On clicking OK, you will get the Link Tables screen, shown in Figure 18.62, where you can select the tables to link to the Access front end.

0 0

Post a comment