Hjälp: Database Link, Add/Edit

The following fields make up a Database Link.

Title
A title for the database link.

DSN
Data Source Name is the unique identifier that Perl uses to describe the location of your database. It takes the format of DBI:[driver]:[database name]:[host].

Example: DBI:mysql:WebGUI:localhost

Here are some examples for other databases.
Oracle:

DBI:Oracle:SID
DBD::Oracle must be installed.
You must be using mod_perl and configure PerlSetEnv ORACLE_HOME /home/oracle/product/8.1.7 in httpd.conf. Without setting ORACLE_HOME, you can connect using DBI:Oracle:host=myhost.com;sid=SID

DBI:PgPP:dbname=DBNAME[;host=hOST]
DBD::PgPP must be installed.

DBI:Sybase:[server=SERVERNAME][database=DATABASE]
DBD::Sybase must be installed.
You must be using mod_perl and configure PerlSetEnv SYBASE /opt/sybase/11.0.2 in httpd.conf.

Database User
The username you use to connect to the DSN.

Database Password
The password you use to connect to the DSN.

Se vidare:

• Database Links, Manage
• Database Link, Delete
• SQL-rapport, lägg till/redigera
• Hjälpindex