Datasheet

Figure 1-19 is the option to connect to a SQL Server (MDF) database file. In this case, you specify the file
location using the Browse button near the bottom of the Add Connection dialog. As before, you must
specify the database server name to which the file will be attached and the authentication type you
want to use.
Another feature is the ability to specify the fine details of the connection. Click the Advanced button
near the bottom of the Add Connection dialog to open the Advanced Properties dialog. For example,
you can turn on or off features such as Multiple Active Results Sets and Asynchronous Processing,
which saves resources and increases efficiency, if you do not require these features. Figure 1-20 shows a
connection to a database file, and some of the many options available in the Advanced Properties dialog.
Figure 1-20: Connecting to a database MDF file and setting the Advanced Properties of
the connection
19
Getting Started
04_588079 ch01.qxd 11/29/05 3:48 PM Page 19