odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
### Issue Description and Expected Result I was trying to build this package locally to see if I can work on a fix for #299. I didn't find any specific...
### Issue Description and Expected Result In a package, I'm trying to use S4 dispatch on one of the concrete connection classes (`"Microsoft SQL Server"`). For this I need to...
Hi all, I’d like to substitute the {RODBCDBI} package with {odbc}. While the following three lines of code work, ``` r con
### Issue Description and Expected Result `odbc::dbListTables` does not return temporary tables unless `catalog_name` parameter is provided. DBI specification and documentation suggests that temporary tables should be returned when default...
A stackoverflow user asked how to do this and there is only a work-around so far, see: https://stackoverflow.com/questions/64950837/cant-insert-dataframe-to-sqlite-table-when-column-names-different-dbwritetable I suggest to support different column names as long as the number,...
### Issue Description and Expected Result This is a very simple question, I've Oracle Instant Client installed, and could connect to my DB with Data Source, but I want to...
This commit introduces a new `odbc::snowflake()` function intended to help setting up connections to Snowflake and handling auth correctly on platforms that provide Snowflake-native OAuth credentials. It generally follows the...
Closes https://github.com/r-dbi/odbc/issues/255 Thought about going couple of different ways here - including masquerading the materialized views as simple "view" s. In the end opted for leaving them marked as they...
This should lighten the usage of the ( sometimes expensive ) `SQLTables` API call to infer the DB hierarchy when connecting. Over time, and if/when needed, we could also make...
Bringing together some information on the Posit Professional Drivers I've pulled together the last few days. The big picture: * In general, the professional drivers themselves can be easily installed...
