How to: Install and Troubleshoot Database Components for Samples (Visual Basic)
Some of the Visual Basic samples use the Northwind database running on Microsoft SQL Server Express; others use SQL Server Compact 3.5. This page describes the installation process.
To download and install SQL Server Express
In Windows, open Internet Explorer.
Click the following URL: https://www.microsoft.com/downloads (Microsoft Download Center)
In the Keywords box, type SQL Server Express.
Click Go.
On the results page, follow the link to the SQL Server Express download page and follow the instructions.
To install the Northwind and Pubs sample databases for SQL Server
In Windows, open Internet Explorer.
Click the following URL: https://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en (Northwind and Pubs Sample Databases)
Click the Download button.
In the File Download box, choose Save This File Now and click OK.
After the file has downloaded, double-click the Nwind.exe file to install the database.
To install the Northwind sample database for Microsoft Access
In Windows, open Internet Explorer.
Click the following URL: https://www.microsoft.com/downloads/details.aspx?familyid=c6661372-8dbe-422b-8676-c632d66c529c&displaylang=en (Access 2000 Tutorial: Northwind Traders Sample Database)
Click the Download button.
In the File Download box, choose Save This File Now and click OK.
After the file has downloaded, double-click the Nwind.exe file to install the database.
To determine your connection string
Open Server Explorer/Database Explorer.
Expand the Data Connections node and select the connection that you want.
Connect to a database on your server.
Right-click the new connection and choose Properties.
In the Properties window, examine the Connection String property. Use this connection string in the samples. The connection string is found in one of these places, depending on the sample:
The code in the form.
The app.config file.
The project settings. Double-click My Project in Solution Explorer and find the connection string setting in the Settings tab.
The dataset files.
Troubleshooting
- The samples expect that the sample database is installed on the local computer in the VSDOTNET instance. If the database is installed somewhere else, you will need to update the connection strings in the sample code.
Security
Always check for product updates when installing additional software.