The syntax used to reference a SQL Server instance is
MyComputer\MySQLServerInstance, where MyComputer is the name of the host computer,
and MySQLServerInstance is the instance you wish to reference.
If only a single SQL Server instance is installed on the local computer, you may be able to, quite
simply, specify (local) as the name of server. Otherwise, you??™ll have to provide the name of the
computer and the SQL Server instance name as described in the previous paragraph.
FIGURE 40-9
Ensuring a successful Access to ODBC to SQL Server connection
13. Click OK on the first screen, and then click OK again on the second screen.
The resulting screen should look like what you see in Figure 40-10.
TIP
1233
SQL Server as an Access Companion 40
FIGURE 40-10
Using an ODBC connection to link to SQL Server using a File DSN
14. If you want to create a User DSN, a System DSN, or both, go ahead and do so. You??™ll
simply be creating multiple data sources to the same SQL Server database. Click OK
to save the new DSN.
Pages:
2243
2244
2245
2246
2247
2248
2249
2250
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267