rodbc Questions
2
Solved
This is my first time connecting to Vertica. I have already connected to a MySQL database sucessfully by using RODBC library.
I have the database setup in vertica and I installed the windows 64-bi...
1
Solved
I have searched quite a bit and read the package documentation, but can't find a solution for this.
I'm using RODBC 1.3-12 against Microsoft SQL Server with the below details.
DBMS_Name "Microsof...
Sphingosine asked 22/10, 2015 at 14:34
2
I've got a very basic SQL query that I'd like to be able to view in R.
The trouble is, I need to be able to reference a #table:
select
RAND(1) as random
into #test
select * from #test
Is t...
1
Solved
I'm trying to catalog the structure of a MSSQL 2008 R2 database using R/RODBC. I have set up a DSN, connected via R and used the sqlTables() command but this is only getting the 'system databases' ...
1
I followed this guide http://eriqande.github.io/2014/12/19/setting-up-rodbc.html to get RODBC working with MAC and I am able to connect to the DB.
Marcos-MacBook-Pro:~ MarcoB$ isql -v ODBC_SQLSS_R...
1
Solved
I'm creating a table and writing it to a database with RODBC. No problems.
First I tried updating the table in R and writing the updates back line by line using sqlUpdate in the same R script and ...
Stretcherbearer asked 8/6, 2015 at 13:56
3
Solved
library(RODBC)
con <- odbcDriverConnect("driver=SQL Server; server=name")
df <- data.frame(a=1:10, b=10:1, c=11:20)
Trying to upload the dataframe:
sqlSave(con, df, tablename='[MyDatabase]...
4
Solved
I have been trying to install some packages such as RODBC, ROracle or RGtk2 - used for rattle. I would really appreciate it if someone could help me get around this problem so that I could use thes...
1
I have a variable in R that I would like to pass to a database. I could use paste like many suggest when reading Google results, but that is unsafe because of SQL injection vulnerabilities. I'd rat...
1
Solved
After I use
cn<-odbcConnect(...)
to connect to MS SQL Server. I can successfully get data using:
tmp <- sqlQuery(cn, "select * from MyTable")
But if I use
tmp <- sqlFetch(cn,"MyTa...
0
I have come across similar posts, but my issue looks different. I haven't been able to fix the results to these queries with "rows_at_time=1" or "believeNRows = False".
I am trying to connect to ...
1
Solved
Does anyone know how to do this? showConnections won't list any open connections from odbcConnect.
1
Solved
I'm attaching, detaching, and re-attaching RODBC and data.table. When I perform this process with these packages in this order, I get the following error:
Error : .onLoad failed in loadNamespace()...
Tensive asked 6/5, 2014 at 15:25
1
I'm using RODBC to connect to a microsoft access database. Some queries work fine, but on one I keep getting the errors:
07002 -3010 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. E...
4
Solved
Am using the RODBC library to bring data into R. I have a long query that I want to pass a variable to, much like this SO user.
Problem is that R interprets the whitespace/carriage returns in my ...
Cleavers asked 14/11, 2012 at 18:2
2
I use RODBC with R and knitr to do some reporting using various production databases. In some of these reports I'm running multiplie queries against multiple databases.
Each of my queries is carri...
1
Solved
I´m trying to connect R and Teradata using RJDBC.
I´ve found this link that has an example using mysql, but i´m nos sure how to do the same with teradata.
library(RJDBC)
drv <- JDBC("com.mysq...
3
Solved
I am fetching data from MySql Server into R using RODBC.
So in one column of the database is a character vector
SELECT MAX(CHAR_LENGTH(column)) FROM reqtable;
RETURNS 26566
Now I will show you...
1
Solved
I'm using RStudio and SVN repository to version control my R projects and files. Usually I fetch data from database at the beginning in these scripts. I'm using RODBC like this:
channel <- odbc...
4
Solved
I'm getting a new error which I've never gotten before when connecting from R to a GreenPlum PostgreSQL database using RODBC. I've gotten the error using both EMACS/ESS and RStudio, and the RODBC c...
Jillene asked 23/8, 2011 at 20:43
1
2
I am running R on unix and I am using the RODBC package to connect to MS SQL server. I can execute a query that returns results fine with the package, but if I use a temporary table somewhere in my...
Firth asked 20/1, 2011 at 13:37
5
Solved
Issue: RODBC (falsely) returning zero rows
Situation:
I'm using RODBC to connect to a DSN I created using a commercial DB's ODBC driver (OSI Soft's PI Historian Time Series DB, if you're curious)...
1
Solved
i am trying to install RODBC with the commadn R CMD INSTALL -l /my/local/path RODBC.tar.gz and it wont find sql.h and sqlext.h ..how do i pass the include and lib paths to this command?
1
Solved
RODBC is the main library in R to import data from a database into R. RODBC seems to have the ability of "guess" the datatype of the column which I find it particularly annoying.
I have u...
© 2022 - 2024 — McMap. All rights reserved.