Contents Index Specifying a database on a server Using the iAnywhere JDBC driver

ASA Programming Guide
  JDBC Programming
    Using the jConnect JDBC driver
      Supplying a URL for the server

Database options set for jConnect connections

When an application connects to the database using the jConnect driver, two stored procedures are called:

  1. sp_tsql_environment sets some database options for compatibility with Adaptive Server Enterprise behavior.

  2. The spt_mda procedure is then called, and sets some other options. In particular, the spt_mda procedure determines the QUOTED_IDENTIFIER setting. To change the default behavior, you should modify the spt_mda procedure.


Contents Index Specifying a database on a server Using the iAnywhere JDBC driver