Products Downloads


French version


 

The database access interfaces supplied with Adelia Studio let you connect to a database by specifying a complete connection chain that fully defines the database.

 

This method is used to connect to a remote base with no need to configure the DBMS client. (The DBMS client must nevertheless be installed.)

 

You can specify a URL from anywhere in the application that lets you input a database name (with the exception of the version manager).

 

For an environment or a buffer, an URL can contain a substitution schema to replace the default schema (SYSADEL) for Adelia tables. This syntax is only supported if the notion of schema is supported by the DBMS (DB2, Oracle or SQL Server).

 

The URL's syntax, which is specific to Adelia, depends on the DBMS:

DB2

[<schema>/]<base>@<serveur>[:<port>]*

 

schema    CASE only: name of the schema used instead of SYSADEL to access the data of the Adelia environment.

base         database name.

server      name or IP address of the database server.

port          port on which the DB2 instance listens (default port: 50000).

 

e.g.: TEST@TEST_SERVER:50000

 

Oracle

<base>[@<server>[:<port>]*]

 

schema    CASE only: name of the schema used instead of SYSADEL to access the data of the Adelia environment.

base         Oracle instance name.

server      name or IP address of the database server (default value: client machine address).

port          port on which the Oracle listener listens (default port: 1521).

 

e.g.: TEST@TEST_SERVER:1521

 

SQL Server

<base>[@<server>[\<instance>]*]

 

schema    CASE only: name of the schema used instead of SYSADEL to access the data of the Adelia environment.

base         database name.

server      Windows name of the database server (default value: client machine name).

instance   SQL Server instance name.

 

e.g.: TEST@TEST_SERVER\SQLExpress

 

MySQL

<base>[@<server>[:<port>]*]

 

base         database name.

server      name or IP address of the database server (default value: client machine address).

port          port on which the MySQL server listens (default port: 3306).

 

e.g.: TEST@TEST_SERVER:3306

  

 

* Parameters shown between square brackets [] are optional.

 

Back to the Cataloguing an Environment topic

 

↑ Top of page

  • Aucune étiquette