similar to: Connection to Microsoft SQL Server

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

Hi, I am trying to read data from Microsoft SQL. I tried to use odbcConnect (in RODBC) but failed. What should the "dsn" be? Does anyone know how to do it? I will appreciate it. Thank you! Xiaorong ________________________________________________________________________ The preceding e-mail message (including any attachments) contains information that may be confidential, be

Deare R users I am new to R. What I want to do is explained below;- I have table called States.Prob which is given below Prob of States Changes State1 State2 State3 State4 A Pa1 Pa2 Pa3 Pa4 B Pb1 Pb2 Pb3 Pb4 C Pc1 Pc2 Pc3 Pc4 D Pd1 Pd2 Pd3 Pd4 and I have a dataframe called

I use RODBC as my conduit from R to SQL. It works well when the tables are stored on one channel, e.g., channel <- odbcConnect("data_base_01", uid="....", dsn="....") However, I often need to match tables across multiple databases, e.g., "data_base_01" and "data_base_02". However, odbcConnect() appears limited insofar as you may only query

No its not an or condition. Please see the changed attachment. Many thanks for your help. Regards Meenu On Wed, Aug 5, 2009 at 6:36 PM, David Winsemius <dwinsemius at comcast.net>wrote: > > On Aug 4, 2009, at 2:12 PM, Meenu Sahi wrote: > > Dear R Users >> >> I'm writing my first simulation in R. >> I've put across my problems with a smaller example

Deare R users I am new to R. What I want to do is explained below;- I have table called States.Prob which is given below:- This table gives the probabilities of the changes in the swap curve depending on the state of the swap curve. I want to put these probabilities in my dataframe mydata(given after the prob table). Prob of States Changes State1 State2 State3 State4 a

Hello, I want to leave pwd blank (to comply w/ company security protocol) and just be prompted by the driver-specific data source dialog box to enter the password after. But for some reason it is not working. R Version: "R version 2.15.1 (2012-06-22)" R Studio Version: 0.97.312 OS: Windows 7 library(RODBC) ##HERE IS THE CODE THAT DOES WORK ##my DSN, UID, PWD is entered something like

Hi all, I am encountering an RODBC problem in R 2.15.1 in windows 64 bit which I do not encountered in the same set up in windows 32 bit (the latest binary version of RODBC in both cases from the same depository gotten by install.packages(‘RODBC’), Oracle ODBC client software installed in 64 and 32 bit respectively) 1. The code looks like library(RODBC) credentials <-

Hello Folks, I do hope this is the correct place to post (and not in R-SIG-DB). I have spent the better part of a day searching for an answer to this question, and have yet to resolve it. I am trying to query an .accdb Access database (with 32-bit Office 2007 currently residing on the machine) with 64-bit R via RODBC. There seem to be some conflicting accounts as to whether or not this is

Dear Users I have a dataframe called mydata4 of the following order with the first column as a date and the rest of the columns are numeric with rate. Column 1 Rate1 : Rate 20 (PxMid) 01/01/2003 07/01/2001 ---- ---- -- I wish to sort this dataframe on the first col in ascending order. I tried to do the following mydata4<-mydata4[,order(mydata4$PxMid)] This give an error. Please help.

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

I am having a problem with RODBC's connections. It appears that my connection to the database is closed by R automatically before I am done with it. Here is my code: foo <- function(dsn) { db <- odbcConnect(dsn) odbcSetAutoCommit(db, FALSE) data <- someDatabaseOperation(db) data2 <- someLongCalculation(data) anotherDatabaseOperation(db, data2) # This often fails b/c the

I am trying to restart on R after 2 months stop. Start with previously functioning procedure: "ch<-odbcConnect("dBase Files")" get "Warning message: ODBC connection failed in: odbcConnect("dBase Files") " I have tried unsuccessfully different working directories. The only change I see is that I am working with a new login account on the same machine.

Under WinXP, I have a system DSN called foo. It has stored username/password information. (I can click Configure in ODBC Administrator and then Test Data Source connects to MySQL without me re-entering data.) Using RODBC, I can connect to the same database. But when I do odbcConnect("foo"), I get a window that requires me to re-enter username/password information. It seems like

Happy New Year to all in the list! I am trying to issue an SQL query to a database from R using RODBC (on Windows). The data source file is on my PC hard disk : C:\Program Files\ODBC\sql.dsn The "\" character does not get interpreted properly in R - it is removed from the file-spec string or if I specify "\\" it appears as such with a syntax error in odbcConnect(dsn,

Hi all, I'm having trouble connecting to an oracle database using RODBC under winXP. Unfortunately I can't really send a reproducable error as the initial call to odbcConnect seems to hangs R and I have to kill the session. I have been using RODBC to sucessfully connect to an MS Access DB that has tables linked through to the oracle database in question and that seems to work OK but it

Hi I know that it is very easy to import data from a dbf file to R, by saving the data as csv, for instance. However, I have several hundreds of files to do that. So, I thought of using RODBC to read the dbf files and save it as data.frame. However, I cannot even start (this is my first time using such package): > library(RODBC) > bdades <- odbcConnect("prova.DBF") Warning

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the

I've been trying to get RODBC working in RAqua. For my database, let's call it "mydb", when I enter odbcConnect("mydb") or odbcConnect("mydb", uid="postgres", pwd="secret"), RAqua thinks for about 10 seconds, then crashes. mydb is a PostgreSQL 7.4.2 database running on my machine (Mac OS X 10.3.3). I am using the pgsqlodbc 7.2.5 driver

Apologies, but after a fair amount of digging, I still only have a foggy understanding of the cause of this problem, due to my own ignorance. I hope to use RODBC package to connect to an Access DB when running 64 bit Win7 (R version 2.11.1, 64 bit). I have successfully done this before on a winXP machine. Currently I am unable to establish a connection using odbcConnect("") (I am