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.
ADO.NET
OLE DB
DataSource='datasource_name'
None
For the SNC interface for SQL Server 2005, specifying a value for Server on the Connection page or specifying a value for SQLCA.ServerName in code 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.
To use the Microsoft OLE DB Provider for ODBC to connect to the EAS Demo DB:
Database profile Enter EAS Demo DB in the Data Source box on the Connection page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="DataSource='EAS Demo DB'"
To use the Microsoft OLE DB Provider for Oracle to connect to an Oracle 8 database:
Database profile Enter the Oracle 8 server name in the Data Source box on the Connection page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="DataSource='Or8server'"
