The connection string can be set to a series of "option=value" pairs, separated by semicolons. If a connection string property value has special characters such as semicolons, single quotes, spaces, 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 User and Password. Caching Data can be enabled by using the appropriate options.