idaConnect: Open or closes a IDA database connection

In ibmdbR: IBM in-Database Analytics for R

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)

ibmdbR documentation built on Nov. 24, 2023, 5:09 p.m.