Class DataSource - Stonefield Query SDK

Class DataSource

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.

System.Object
  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: SFQWrapper
Assembly: sfqwrapper.dll