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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Using UltraLite databases » Connecting to an UltraLite database » UltraLite database connection parameters

 

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. An application can parse the fields of a ConnectionParms object into a string, or you can type a connection string on a single line with the parameter names and values separated by semicolons:

parameter1=value1;parameter2=value2

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 parameter.

 Precedence of connection parameters for UltraLite administration tools
 Limitations
 See also