Database connections
Contents
If you are deploying an executable or component that accesses a
database, your users need access to the DBMS and to the database your
application uses.
Where to install database connectivity files
You do not need to deploy database connectivity files with a
client application that relies on a middle-tier component on another
computer to perform database transactions. Database connectivity files
must be deployed on the computer that interacts with the database
server.
You need to:
-
If necessary, install the DBMS runtime (client) files in the
application directory or in a directory on the system pathIf your application uses a standalone SQL Anywhere database, you
can install the SQL Anywhere Runtime Edition files on the user’s
computer. For more information, see SQL Anywhere files. Otherwise
follow the instructions and licensing rules specified by the
vendor. -
Make sure each user has access to the database the application
usesIf your application uses a local database, install the database
and any associated files, such as a log file, on the user’s
computer.If your application uses a server database, make sure the user’s
computer is set up to access the database. This may be the task of a
database administrator. -
Install any database interfaces your application uses on the
user’s computer -
If your application uses the ODBC interface, configure the ODBC
database drivers and data sources, as described in Configuring ODBC data sources and
drivers
For more information about database drivers and interfaces,
see: