Identifies the data source to which you want to connect. The data source can be a file, a database, or an ODBC data source depending on the OLE DB data provider you are using.
When to specify DataSource
You must specify the DataSource parameter before connecting
to the database.
OLE DB
DataSource='datasource_name'
None
For the SNC interface for SQL Server 2005, specifying a value for Server on the Connection page is equivalent to setting this parameter.
The value of the Data Source parameter varies depending on the type of data source connection you are making. For example, if you are using Microsoft’s OLE DB Provider for ODBC, you would enter the actual ODBC data source name for the Data Source value. If you are using Microsoft’s OLE DB Provider for SQL Server, you would enter the actual Microsoft SQL Server server name for the Data Source value.
For more information, see the documentation provided by your OLE DB data provider.
Example 1 To use the Microsoft OLE DB Provider for ODBC to connect to the EAS Demo DB, enter EAS
Demo DB in the Data Source box on the Connection
page in the Database Profile Setup dialog box.
Example 2 To use the Microsoft OLE DB Provider for Oracle to connect to an Oracle 8 database, enter the Oracle 8 server name in the Data Source box on the Connection page in the Database Profile Setup dialog box.
