Create a database description (class 'edb'), to be used by other functions.

Description

Create a database description (class 'edb'), to be used by

other functions. Notice that this is _not_ a database connection,

so the function won't give a warning if the database does not

exists (yet) or if some parameters are wrong.

Usage

1
2
3
4
5
6
7
edb(dbType, dbName, dbSourceName = "edbDefault", dbHost = "", 


    dbLogin = "", dbPwd = "", dbPort = integer(0), 


    ...)

Arguments

dbType

Single character string. Type of the database to describe,

formatted as RPackageName_DatabaseType. Possible values

are RSQLite_SQLite, RODBC_Access or

RODBC_MySQL.

dbName

Single character string. Name of the database to describe

(should include the path to the database if it is not in the

working directory. MySQL database have no path of course).

Not to be confused with the data source name below.

dbSourceName

Single character string. Name of the data source (only ODBC

databases) for this database.

dbHost

Single character string. The IP address of the remote database

server (only for RODBC_MySQL).

dbLogin

Single character string. Database login (or user name). Only

for certain dbType (only for RODBC_MySQL).

dbPwd

Single character string. Database password (eventually user

specific). Only for certain dbType (only for RODBC_MySQL).

dbPort

Single integer. The connexion port to the database (only for

RODBC_MySQL).

...

Additional named arguments, to be passed to the function used

to connect to the database (internally).

Author(s)

Julien MOEYS <Julien.Moeys@mark.slu.se>

See Also

edbRead, edbWrite,

edbNames, edbColnames.