Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Connecting to an UltraLite Database » Opening UltraLite connections with connection strings

Supplying UltraLite connection parameters Next Page

Assembling parameters into UltraLite connection strings

An assembly of connection parameters supplied in any application's connection code (be it an administration tool or a custom UltraLite application) is called a connection string. In some cases, applications parse the fields of a ConnectionParms object into a string. In others however, you type a connection string on a single line with the parameter names and values separated by semicolons:


The UltraLite runtime ensures the parameters are assembled into a connection string before establishing a connection with it. For example, if you use the ulload utility, the following connection string is used to load new XML data into an existing database. You cannot connect to the named database file until you supply this string:

ulload -c "DBF=sample.udb;UID=DBA;PWD=sql" sample.xml

UltraLite does not ignore unrecognized connection string parameters. Instead, it generates an error for unrecognized connection parameters.

Precedence of parameters for UltraLite administration tools

All of the UltraLite administration tools follow a specific order of parameter precedence:


Any leading spaces and/or trailing spaces in connection string parameter values are ignored. All connection string parameters cannot include leading single quotes ('), leading double quotes ("), or semicolons (;).

See also

Specifying file paths in an UltraLite connection parameter