RSSBus ADO.NET Provider for QuickBooks V2
The connection string properties describe the various options that can be used to establish a connection.
Assembly
System.Data.RSSBus.QuickBooks.dll
Remarks
The ConnectionString property of the QuickBooksConnection object can be set to a series of option=value strings separated by semicolons. If a connection string property value has special characters like semicolon, single-quote, or space etc., then you must quote the value using either single or double quotes.
Connection options are case insensitive.
To specify a location to the database where the tables, views and stored procedures are located, set the Location property. In addition you must also set URL, User and Password if QuickBooks is not installed in the local machine and you are using the QuickBooks Remote Connector. Caching Data can be enabled by using the appropriate options.
Connection String Options
The following is the full list of the options you can configure in the connection string for this provider. Click on the links for further details.
| Application Id | The ID of the application assigned by Intuit. |
| Application Name | The name of the developer's application. |
| Auto Cache | Controls automatic caching of data returned by the provider. |
| Cache Location | Specifies the path and file name of the cache database. |
| Company File | The name of the company file to open. |
| Connection Ticket | The connection ticket for QuickBooks Online Edition. |
| Delay After Close | A delay, in milliseconds, to be applied after each time a connection to QuickBooks is closed. |
| Firewall Password | A password, if authentication is required to connect through a firewall. |
| Firewall Port | The TCP port for the firewall FirewallServer . See the description of the FirewallServer option for details. |
| Firewall Server | Specify a firewall name or IP address to authenticate requested connections, if necessary. |
| Firewall Type | The type of firewall to connect through. |
| Firewall User | A user name, if authenticating a connection to a firewall. |
| Include Line Items | Whether or not to request LineItem responses from QuickBooks when retrieving a base transaction such as Invoices. |
| Include Linked Txns | Whether or not to request Linked Transactions from QuickBooks when retrieving a base transaction such as Invoices. |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures for the data provider. |
| Logfile | A path to the log file. |
| Offline | Forces the provider to work in offline mode. |
| Online Login | Your user login for QuickBooks Online Edition. |
| Other | The other parameters necessary to connect to a data source, e.g. username and password when applicable. |
| Password | A password for the Remote Connector connection. |
| Proxy Auth Scheme | The proxy server authorization scheme (default: BASIC). |
| Proxy Auto Detect | Whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings. |
| Proxy Password | A password, if authenticating with a proxy server. |
| Proxy Port | The TCP port for the proxy ProxyServer (default: 80). |
| Proxy Server | If a proxy server is given, then the HTTP request is sent to the proxy instead of the server otherwise specified. |
| Proxy SSL Type | The SSL type to use when connecting to the proxy server (default: AUTO). |
| Proxy User | A user name, if authentication is to be used for the proxy. |
| Pseudo Columns | Indicates whether or not to include pseudo-columns as columns to the table. |
| QBXML Version | The version of QBXML used in the outgoing message. |
| Query Passthrough | Controls how queries in Offline mode are executed. |
| RTK | The runtime key for the data provider. |
| Session Ticket | The session ticket for QuickBooks Online, which lasts for a single session. |
| SSL Accept Server Cert | The SSL certificate being used by the Remote Connector. |
| Tables | Comma separated list of tables to be listed by the data provider. E.g., Tables=TableA,TableB,TableC;. |
| Timeout | A timeout, in seconds, for the Remote Connector connection. |
| URL | The URL for the Remote Connector. For example: 'http://localhost:2080'. |
| User | A username for the Remote Connector connection (if required by the Remote Connector). |
| Verbosity | The verbosity level for the logging. |