similar to: RODBC and OS X

This is my second posting on this topic, the first recieved no replies. Has anyone successfully used RODBC on the OS X platform? I've tested the ODBC drivers I'm using with two other applications and I've had no problems. I begining to think the problem is with R/RODBC and not the drivers. Here are the specifics: I'm having a problem connecting to an MS SQL Database via RODBC

I am trying to connect sybase sql databast from R using RODBC pkg and getting the following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver

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

> On Jun 20, 2016, at 9:19 AM, Spencer Graves <spencer.graves at prodsyse.com> wrote: > > "R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as follows: > > > >* checking package dependencies ... ERROR > >Package suggested but not available: ?RODBC? > > > >The suggested packages are required for a complete check. >

iODBC appears no longer to come standard with OSX, so I installed unixodbc and set it up following instructions here: http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/ I connected to my remote database with isql -v mydsn. No problem. Then I tried from R: > library(RODBC) > pg <- odbcConnect("mydsn")  # waited for a couple of minutes before pressing

I am trying to get access to a Microsoft SQL Server 2k installation on my network. To this point I''m not having any luck. I''ve followed the instructions at http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX up to the point where you run the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an

Dear All, As some of you in the archive, i am experiencing problems in using RODBC with IODBC on Mac OS X Panther. I am currrently facing two problems. The first one is apparently linked with IODBC (according to returned R error message) although testing the database access from IODBC manager seems to work fine. The second is by far more radical, R purely and simply reports an error ,

Hello. It's possible to use IODBC instead UNIXODBC with realtime? As I see, the res Makefile load a odbcinst.h file, but in IODBC there's not this file. I change the res Makefile (iodbcinst.h instead odbcinst.h) and the make create the res_odbc.so. But when asterisk boot it don't start showing: [res_odbc.so]Oct 4 10:24:43 WARNING[9748]: loader.c:314 __load_resource: libiodbc.so.2:

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 all, I try to use RODBC on my mac machine. I google a lot but could not find a very comprehensive tutorial. Finally, I install iODBC, but there's no driver in iODBC. And I found some commercial ODBC driver. Actaully I just want to learn it ,so free driver will be suitable for me. Does anyone how to use RODBC on mac environment ? And is there any comprehensive tutorial on it ? Thanks --

hi, i am using the RODBC package to read .xls files. now after i installed the package and loaded the library and tried to read a file this is the error i got. >channel<-odbcConnect("D:/rstuff/1.xls") Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed

Dear r-helpers, After updating to R version 2.2.1, 2005-12-20, powerpc-apple- darwin7.9.0 (from binary), JGR wouldn't launch. I then deleted everything I could find related to JGR, and reinstalled it from the latest binary. Both R and JGR are installed in /Applications/ \~LocalApps/mathStat/. Advice on how to identify the source of the problem? My machine: Machine Name:

I haven't been able to find any help on this and am really struggling. I've been using RODBC 1.1-3 and R(D)COM v1.35 for a little over a year successfully with my Access Database, and now im switching to Oracle 9i. I use R 2.0.1 on a Windows XP platform, 1GB ram, 2GHz Intel Processor) When I connect through the Rgui R console, the connection is successful (but through VB the attempt

Hi, I'm trying to get to grips with accessing my postgresql tables in R using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0 installed from source and I have updated RODBC to 1.0-4. On the ODBC manager end, I am using OpenLink software's iODBC Administrator and I've set up a User DSN called "PostGRES" - odbctest suggests that this is functioning: >

I get the following errors when attempting an ODBC connection to a MySQL db. 1: [RODBC] ERROR: state HY000, Code 0, message [MySQL] [ODBC 3.51 Driver] Could not determine the driver name so could not lookup setup library. 2: ODBCConnection failed in: odbcDriverConnect(st, case=case, believeNRows=believeNRows). Win XP sp2 MySQL 4.1.8 My SQLODBC 3.51.10 Package RODBC (latest) is installed.

Graham, nice package this :-)-O. It was easy to set up MySQL but I struggled immensely to get the stock ODBC working with PostgreSQL (8.3), which has been discussed on the mailing list before (Prof Brian): Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing

Hello Users: I'm using R version 2.0.1, and having problems with RODBC. Everything works fine when I use Rgui, but when I try to use Rterm and issue the commands library(RODBC) con <- odbcConnect("MySQL", "test") I get the following error: Error in sqlQuery(con, str) : first argument is not an open RODBC channel In addition: Warning messages:

I'm using RODBC to connect to a MS SQL server. I've been able to get it to work without much of a hitch in windows. However, I'm using OpenLink's iODBC drivers on the Linux side and I'm not sure how RODBC is able to find information about the dsn's (which is in the odbc.ini file?). I've tested the connection with the test program included by OpenLink and

Hello All i need to transfer CDR data from linux to MS SQL Serever (on Windows). writing by Perl. I have download and install UnixODBC, DBI, DBD from CPAN, when i tested isql -DSN -UID - PWD, that's successful, but when run by perl, message alert could not loaded driver database, .... anybody used ODBC for linux, connect to MS SQL Sevre, please help me? easysoft and openlink have

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,