Selecting a Data Provider (SQL Server, MS Jet, and so on)

By default, Visual Basic assumes that you're working with SQL Server when you create a data connection. However, you can change that when you create a connection by informing Visual Basic of your actual data provider.

You can tell Visual Basic which data provider you're using when you create a data connection (see "Creating a New Data Connection" in this chapter), which you do using the Data Link Properties dialog. Simply click the dialog's Provider tab, as you see in Figure 20.6, and select the data provider you want to work with.

For an example that uses MS Jet 4.0 as a data provider, see "Connecting to an MS Jet Database" in this chapter.