Complete this step to specify the location and name of the data to be accessed.
What is the location of the data?
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. |
What is the data source for the data?
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 |
See Also
Create New Data Link Wizard: Step 1