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

MemberDescription

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

© Stonefield Software Inc., 2023 • Updated: 02/27/12
Comment or report problem with topic