idaConnect, idaClose {ibmdbR}

Open or closes a IDA database connection

Description

These functions are used to open or close an existing IDA database connection.

Usage

idaConnect(dsn, uid = "", pwd = "", conType = "odbc", 
  dsnLookup = c("auto", "default", "store"), ...)

idaClose(idaConn, conType = "odbc")

Arguments

dsn

The DSN of the data base.

uid

The user name.

pwd

The password.

conType

The connection type.

dsnLookup

This parameter only is used when ibmdbR is loaded in an RStudio instance of IBM Data Science Experience. Per default ("auto") ibmdbR automatically detects if the provided dsn value is an usual DSN string or the name of a connection in the local connection store. The lookup method can also be manually set to "default", if the dsn parameter should be treated as an usual DSN string. If set to "store" the connection store of RStudio on DSX will be used.

...

Additional arguments for DSN lookup.

idaConn

The connection object.

Details

Opens or closes a connection to a database. Currently, RODBC is used as underlying library, this might change, however, in the future.

Examples

## Not run: 
#Connect locally 
con <- idaConnect('BLUDB','','')

#Close the connection
idaClose(con)

## End(Not run)