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, you type a connection string on a single line with the parameter names and values separated by semicolons:
The UltraLite runtime ensures that 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 generates an error when it encounters an unrecognized connection parameters.
All of the UltraLite administration tools follow a specific order of connection parameter precedence:
Any leading and/or trailing spaces in connection string parameter values are ignored. Connection parameter values cannot include leading single quotes ('), leading double quotes ("), or semicolons (;).
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|