Connection parameters
46
Connection parameters
This section describes each connection parameter. Connection parameters are
included in connection strings. They can be entered in the following places:
♦ In an application’s connection string. For more information, see
"Assembling a list of connection parameters" on page 69 of the book
ASA User’s Guide.
♦ In an ODBC data source. For more information, see "Working with
ODBC data sources" on page 49 of the book ASA User’s Guide.
♦ In the Adaptive Server Anywhere connection window. For more
information, see "Connecting from Adaptive Server Anywhere utilities"
on page 48 of the book ASA User’s Guide.
The ODBC configuration dialog and the Adaptive Server Anywhere
connection window for Windows operating systems share a common format.
Some of the parameters correspond to checkboxes and fields in these
windows, others can be entered in the text box at the end of the Advanced
tab.
♦ Connection parameters are case-insensitive.
♦ The Usage for each connection parameter describes the circumstances
under which the parameter is to be used. Common usage entries include
the following:
♦
Embedded databases When Adaptive Server Anywhere is used
as an embedded database, the connection starts a personal server
and loads the database. When the application disconnects from the
database, the database is unloaded and the server stops.
♦
Running local databases This refers to the case where an
Adaptive Server Anywhere personal server is already running, and
the database is already loaded on the server.
♦
Network servers When Adaptive Server Anywhere is used as a
network server, the client application must locate a server already
running somewhere on the network and connect to a database.
♦ You can use the dbping utility to test connection strings. For example, if
the database file
MyDB.db
is not currently running, the following string
returns the message
Ping database successful:
dbping -d -c "dbf=c:\Databases\MyDB.db;astart=yes"
The following command, however, returns the message Ping database
failed – Database server not running, because Adaptive Server
Anywhere is unable to find a server for
MyDB.db
:
Notes
To Next Page
Loading...