448 Part IV Database and Web Programming
Note If you get a message that says “Unrecognized database format”, you might not have
Access 2007 or later installed. If you don’t have Access 2007 or later installed, you will need
to download and install the 2007 Office System Driver: Data Connectivity Components
from Microsoft .com. (See Step 1 above .)- Click OK to close the message box, and then click OK to close the Add Connection
dialog box.
Visual Studio displays the Data Source Configuration Wizard again. - Click the plus sign (+) next to the Connection String item in the dialog box to display
your completed connection string.
Your wizard page looks similar to the following:
The connection string identifies a provider (also called a managed provider)
named Microsoft .ACE .OLEDB .12 .0, which is an underlying database component
that understands how to connect to a database and extract data from it. The two
most popular providers offered by Visual Studio are Microsoft OLE DB and SQL Server, but
third-party providers are available for many of the other popular database formats.