Use the Connection tab to specify how to connect to your data.
Provider
Select your OLE DB provider. All OLE DB providers detected on your hard disk are listed.
Location
Enter the location of the data source that you want to access. Typically, this is a server name.
The Location property value varies depending on your OLE DB provider. For example:
| If the OLE DB Provider isà | The Location isà |
| Microsoft Jet 3.51 OLE DB Provider | N/A |
| Microsoft OLE DB Provider for ODBC Drivers | N/A |
| Microsoft OLE DB Provider for SQL Server | A server name. |
| Microsoft OLE DB Provider for Oracle | A server name. |
Data Source
Enter the name of the data source that you want to access. Typically, this is a database name.
The Data Source property value varies depending on your OLE DB provider. For example:
| If the OLE DB Provider isà | The Data Source isà |
| Microsoft Jet 3.51 OLE DB Provider | An Access database (.mdb) file name. |
| Microsoft OLE DB Provider for ODBC Drivers | A Data Source Name (DSN). |
| Microsoft OLE DB Provider for SQL Server | A database name. |
| Microsoft OLE DB Provider for Oracle | N/A |
Connect
Click to attempt a connection to the specified data source.
Results
Indicates whether the connection was successfully created.
If the connection fails, ensure that the settings are correct. For example, spelling errors and case sensitivity may be the cause of a failed connection.
See Also