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

In easydb: Generic S3 Classes for Simple Database Interfaces

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

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 <[e-mail]>

See Also

edbRead, edbWrite,

edbNames, edbColnames.

easydb documentation built on May 2, 2019, 4:47 p.m.