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
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.
When you use this parameter with an AdoTransaction object in DataWindow .NET, set this parameter in the ConnectString parameter of the Connection object. For more information, see “Specifying parameters for ADO.NET and AdoTransaction”.
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 tab in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter = "DataSource='EAS Demo DB'"
To use the PB DataDirect OLE DB Provider to connect to an Oracle 8 database:
Database profile Enter the data source name in the Data Source box on the Connection tab in the Database Profile Setup dialog box. You should have previously defined the data source name using the PB DataDirect OLE DB Administrator.
Application Type the following in code:
SQLCA.DbParameter = "DataSource='Oracle8'"
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 tab in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter = "DataSource='Or8server'"
