odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
I'm inserting duplicated rows in a SQL Server table. If I use `dbAppendTable`, I'm getting a meaningless "[0]" as result. If I use `dbWriteTable` with `append = TRUE`, I'm getting...
### Issue Description and Expected Result I was wondering under which license the odbc package is published. The DESCRIPTION file mentions MIT, but the LICENSE file itself only mentions copyright...
DB2 subclass- find temporary tables in dbExistsTable and dbListTables if possible. Defaults to normal behavior. Thanks to @rnorberg for the suggestion.
### Issue Description and Expected Result `dbAppendTable()` does not return the number of rows affected ### Database PostgreSQL 11.0.6 ### Reproducible Example ``` r library(DBI) # Appends table and gives...
Passing on a request to have the Connections Pane to only show the schemas and tables that the user has access to. This is more likely not something that the...
### Issue Description and Expected Result copy_to not working with given types since odbc 1.3.0 ### Database SQL Server 2016 ### Reproducible Example Example: ```r library(dplyr) library(DBI) con
We have a table `[adj].[Assortment Snapshot]` in our SQL Server database with the follwing data types: ```lang-sql [Customer UUID] [uniqueidentifier] NOT NULL, [Branch Number] [int] NOT NULL, [Article Number] [int]...
Not sure if this is an error in `odbc` or in Azure SQL Database, but if you are using [serverless mode](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-serverless) and the database has auto-paused, creating the connection fails:...
I'd really like to install (from source) the latest version of `odbc`, but at work we're on RedHat 7 so our version of `gcc` is rather old (4.8.5) and predates...
*@brshallo commented on May 7, 2018, 5:21 PM UTC:* I regularly connect to data marts provisioned for me on Microsoft SQL Server. When connecting to Microsoft SQL Server, the RStudio...
