similar to: BUG in RODBC with OS X?

All, I'm having a problem connecting to an MS SQL Database via RODBC on OS X. If I try to connect through the GUI using chan <- odbcConnect("drewdb", uid="user", pwd ="pwd") it simply crashes R with the following crash report: Date/Time: 2005-03-28 12:30:48 -0600 OS Version: 10.3.8 (Build 7U16) Report Version: 2 Command: R Path:

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

I'm a newcomer - obvioulsly I fear. Tried to install RODBC from CRAN mirror onto mahcine 64bit running suse10. terminal log below - it failed on "ODBC headers sql.h and sqlext.h not found" di i need anothe rpackage?? can someone help please? ta v much Prof R Gott Durham UNiv, UK > install.packages(c("RODBC")) trying URL

"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. >Checking can be attempted without them by setting the environment >variable _R_CHECK_FORCE_SUGGESTS_ to a false value.

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 ,

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 --

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:

Hi, I have tried to install.packages("RODBC"), but it balks: Installing source package `RODBC'' ... creating cache ./config.cache checking for library containing SQLTables... no configure: error: no ODBC driver manager found ERROR: Configuration failed for package `RODBC'' What am I missing? What and where should "SQLTables" be? In another package? What

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:

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

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: >

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

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.

Hi, In an app I''m developing I''ve run into a strange problem. I''ve created some controllers and models using the scaffolding generator and everything seemed to work fine. However I''ve noticed that a particular model I''ve created always fails its tests and I can''t test it out in a browser due to the same error I''m getting which is:

There is a new version of RODBC, 0.9-1, with a new maintainer (me) now on CRAN (Vienna) which works with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against

There is a new version of RODBC, 0.9-1, with a new maintainer (me) now on CRAN (Vienna) which works with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against

This may be as much of a Linux Newbie question as an RODBC question. I've managed to get iODBC working on my RedHat 7.2 system. I can load the library and run it as root. However, I would like to be able to run it via Perl and Apache over the web. I'm not sure what I need to change in order to let "nobody" (the user running the scripts off of Apache) load the library. I can