Top "Rodbc" questions

SQL Server RODBC Connection

Does anyone have a connection string example for using RODBC and connecting to MS SQL Server 2005 or 2008. Thank you.

r rodbc

How to connect R with Access database in 64-bit Window?

When I tried to connect R with Access database I get an error odbcConnectAccess is only usable with 32-bit Windows …

r ms-access rodbc

How to insert a dataframe into a SQL Server table?

I'm trying to upload a dataframe to a SQL Server table, I tried breaking it down to a simple SQL …

r rodbc

RODBC odbcDriverConnect() Connection Error

I'm trying to use odbcDriverConnect('driver={SQL Server};server=servername\instancename,port;database=testing;username=abc;password=123456') to connect …

sql-server rodbc

Failure to connect to odbc database in R

I've been trying to connect my company's DMS to R using the odbcConnect command, but get the following message: myConn &…

r rodbc

Pass R variable to RODBC's sqlQuery?

Is there any way to pass a variable defined within R to the sqlQuery function within the RODBC package? Specifically, …

sql r rodbc

How do I connect to an SQL server database in R

I'm trying to connect to the SQL Sever database using R but not sure on the details for the query …

sql-server r rodbc

sqlSave in R to create and save a dataframe to an sql table

Hi I am using R to save a data frame into a DB2 SQL table. I seem to be able …

sql r db2 rodbc

RODBC sqlSave table creation problems

I'm having trouble creating a table using RODBC's sqlSave (or, more accurately, writing data to the created table). This is …

sql sql-server r sql-server-2008 rodbc

Installation of RODBC/ROracle packages on OS X Mavericks

I have been trying to install some packages such as RODBC, ROracle or RGtk2 - used for rattle. I would …

r oracle rodbc