rodbc Questions

8

So this is VERY strange. RODBC seems to drop the time portion of DateTime SQL columns if the result set is large enough. (The queries are running against an SQL Server 2012 machine, and, yes, when ...
Bucaramanga asked 6/4, 2014 at 20:21

4

Solved

I'm running R 2.15.2 on a Red Hat Linux 6 server. My goal is to connect to a MS SQL Server Database on another machine via RODBC. I did my research and downloaded and installed the linux version of...
Convict asked 11/12, 2012 at 12:47

6

Is it possible to perform a bulk insert into an MS-SQL Server (2000, 2005, 2008) using the RODBC package? I know that I can do this using freebcp, but I'm curious if the RODBC package implements t...
Czarra asked 9/9, 2009 at 20:48

4

Solved

I am researching how to read in data from a server directly to a data frame in R. In the past I have written SQL queries that were over 50 lines long (with all the selects and joins). Any advice on...
Kabyle asked 7/4, 2015 at 17:42

6

Solved

I'm having trouble creating a table using RODBC's sqlSave (or, more accurately, writing data to the created table). This is different than the existing sqlSave question/answers, as the problem...
Firth asked 28/5, 2014 at 13:53

3

Solved

I'm trying to upload a dataframe to a SQL Server table, I tried breaking it down to a simple SQL query string.. library(RODBC) con <- odbcDriverConnect("driver=SQL Server; server=database") df...
Rowboat asked 15/1, 2013 at 9:42

5

I'm trying to connect to the SQL Sever database using R but not sure on the details for the query string. I normally use SQL server management studio on SQL Server 2008 and connnect using single si...
Forsake asked 12/11, 2015 at 23:4

2

Solved

I am new to R but am interested in using Shiny to create dynamic charts using data stored in a SQL Server database. To enable interactivity, I want to bring in the raw data from the database and pe...
Histrionics asked 19/6, 2015 at 17:15

2

I am writing to from an ODBC to a SQL Server table via the RODBC package, specifically the function sqlSave. It seems that the default var types is charvar(255) for this function. I tried to use th...
Carvel asked 1/3, 2014 at 4:9

4

Solved

I'm trying to use RODBC to write to an Excel2007 file and I keep getting errors. I've reduced the issue to this very basic case, a 1-row data.frame with character, numeric, Date, and logical dataty...
Scrobiculate asked 15/10, 2011 at 18:35

4

Solved

I use RODBC to send queries to an SQL-Server. Sometimes they take too much time to run, so I need to cancel them. Clicking the red "stop" button in RStudio yields this error message: R is not r...
Shop asked 12/5, 2017 at 17:14

2

Solved

I am trying to pull data from our Oracle datamart into R using RODBC. I have been able to work through some of my issues, but I have one basic question. How can I retain the formatting as it sits ...
Evince asked 22/11, 2010 at 19:3

1

Solved

I have a data frame with 10 million rows and 5 columns that I want to insert to an existing sql table. Note that I do not have permission to create a table, I can only insert values into an existin...
Maori asked 10/5, 2017 at 0:14

2

I'm building an R package, the main purpose of which is to abstract away the pain of dealing with a proprietary database that requires some fairly complex SQL queries in order get data out. As su...
Gerdagerdeen asked 8/2, 2013 at 19:24

3

I am trying to import some data directly into R from a SQL Database. I have set up the connection without an issue but extracting the data has been somewhat challenging. I will try and make this as...
Hamon asked 17/7, 2013 at 15:43

3

My database table looks approximately like this: +-----+-------+--------------------+-----------+----------+ | ID1 | ID2 | FilePath1 | FilePath2 | Status | +-----+-------+--------------------+----...
Tevis asked 14/8, 2012 at 8:42

0

When using RODBC to connect to Microsoft SQL Server I know I can do the following: con <- odbcDriverConnect(connection="driver={SQL Server};server=servername;database=dbname;trusted_connection=...
Manasseh asked 16/2, 2017 at 16:5

4

When installing the R package RODBC in RStudio on OS X Yosemite, I get the following error: configure: error: "ODBC headers sql.h and sqlext.h not found" This is a common error and indicates tha...
Beutler asked 22/1, 2015 at 5:10

2

I'm using the RODBC package inside an ORACLE DATA BASE (DB). Everything is doing very well, but I need to obtain a table from this DB and some variables as character type, not numbers. So, I made...
Piety asked 30/5, 2012 at 19:53

5

Solved

I've set up my ODBC driver so that MS Excel can import the data into a spreadsheet just fine. However, when I try to establish the connection with R, using ch <- odbcConnect(leprosyDHISdb, uid...
Karolyn asked 5/6, 2014 at 5:53

1

Solved

Related to https://stackoverflow.com/a/33284035/3358272, I'm finding inconsistent behavior with pulling data from SQL Server (2014). library(RODBC) sqlQuery(.conn, "CREATE TABLE r2test ( [mychar] ...
Guilty asked 18/7, 2016 at 17:58

1

I know I can create a temporary table in SQL from R with, for example: require(RODBC) X<- odbcDriverConnect('driver={SQL Server}; server=s001000;database=X1;trusted_connection=true') sqlQuer...
Jarred asked 9/5, 2016 at 14:10

4

Solved

Is there any way to pass a variable defined within R to the sqlQuery function within the RODBC package? Specifically, I need to pass such a variable to either a scalar/table-valued function,...
Stupor asked 1/12, 2010 at 23:8

1

Solved

I need help to write a simple data row to SQL server from R Language. (using RODBC or otherwise).
Pudding asked 4/1, 2016 at 12:42

2

Solved

I have a SQL table called "Customers". In it is a CustomerNumber field with values like "0001234567", i.e. they are made up of numbers only, but some include leading 0s. So, when I try to run somet...
Archaeopteryx asked 11/12, 2015 at 17:51

© 2022 - 2024 — McMap. All rights reserved.