Defines the connection information for a physical instance of a Database object.
Please note that any changes you make to this item will only be saved in Stonefield Query after you call the Dispose() method.
SFQWrapper.SQBase
SFQWrapper.SQItem
SFQWrapper.DataSource
public class DataSource : SQItem
Class Members
Member | Description | |
---|---|---|
Connect |
Connects to the data source. public bool Connect(); |
|
Disconnect |
Disconnects from the data source. public bool Disconnect(); |
|
BaseURL |
The base URL queries are sent to (only applicable if Type is "SQLXML"). |
|
CommandTimeout |
Specifies the command timeout setting for the ADO Connection object (only applicable if Type is "ADO"). Set this to a higher value to avoid timeout issues with queries on large tables. |
|
ConnectionHandle |
The ODBC connection handle for the connection (only applicable if Type is "ODBC"). |
|
ConnectionString |
The connection string to use to connect to the database (only applicable if Type is "ADO" or "ODBC"). |
|
ConnectionTimeout |
Specifies the connection timeout setting for the ADO Connection object (only applicable if Type is "ADO"). |
|
Database |
The name of the physical database this data source connects to. In the case of file-based database engines such as Visual FoxPro and Access, this must include the path to the database. In the case of text files, this must contain the path for the files. |
|
Datasource |
The name of the DataSource. |
|
Description |
The descriptive name for the data source. |
|
Driver |
The name of the ODBC driver to use (only applicable if Type is "ODBC"). This must be the exact name as displayed in the ODBC Administrator dialog. |
|
DSN |
A user or system data source name (DSN) defined on the user's system that connects to the data source (only applicable if Type is "ODBC"). Leave this property blank if you want to use a "DSN-less" connection, one that doesn't require a DSN on the user's system. |
|
ErrorMessage |
The message for any error that occurred. |
|
Method |
The method of the Web service to call (only applicable if Type is "WebService"). |
|
OtherConnectInfo |
Additional information to pass to the ODBC driver (only applicable if Type is "ODBC"). For example, for protected Access databases, you have to specify "SystemDb=path for MDW file." |
|
Password |
The password to access the database (only applicable if Type is "ADO" or "ODBC"). |
|
Server |
The server the database is located on (only applicable if Type is "ODBC"). |
|
Specifier |
The database specifier name (only applicable if Type is "ODBC"). |
|
Type |
The type of data source: "ODBC," "ADO," "VFP," "WebService," "SQLXML," or "Text". |
|
UserDefined |
User-defined information about the datasource. |
|
UserName |
The user name to access the database (only applicable if Type is "ADO" or "ODBC"). |
|
UseTemplate |
True if queries are sent to a template; False (the default) to include the SQL statement in the URL (only applicable if Type is "SQLXML"). |
|
WSDLURL |
The URL of the WSDL file for the Web service (only applicable if Type is "WebService"). |
Requirements
Namespace: SFQWrapperAssembly: sfqwrapper.dll
© Stonefield Software Inc., 2023 • Updated: 02/27/12
Comment or report problem with topic