odbcReConnect: If ODBC connection not functioning, re-connect.
In ds4ci/ds4ciMisc: Miscellaneous Functions for DS4CI Projects
Description
Usage
Arguments
Details
Value
Description
Attempts to create a dplyr::tbl() object. If that fails, then odbc::dbConnect() to
re-connect.
Usage
1
odbcReConnect(con, on_table = dbplyr::in_schema("pg_catalog", "pg_type"))
Arguments
con
An established DBI/odbc connection object
on_table
The DB table, possibly in a schema, to use for test.
Details
Note: odbc::IsValid does not check the connection is actually still live, which
is why we use dplyr::tbl() to test.
Will throw error Could not re-establish connection., if new connection is not
identical() to original.
Value
The original, or re-estbalished, connection.
ds4ci/ds4ciMisc documentation built on May 15, 2019, 2:56 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details Value
Description
Attempts to create a dplyr::tbl() object. If that fails, then odbc::dbConnect() to re-connect.
Usage
1 | odbcReConnect(con, on_table = dbplyr::in_schema("pg_catalog", "pg_type"))
|
Arguments
con |
An established DBI/odbc connection object |
on_table |
The DB table, possibly in a schema, to use for test. |
Details
Note: odbc::IsValid does not check the connection is actually still live, which
is why we use dplyr::tbl() to test.
Will throw error Could not re-establish connection., if new connection is not
identical() to original.
Value
The original, or re-estbalished, connection.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.