similar to: BUG in RODBC with OS X?

Displaying 20 results from an estimated 400 matches similar to: "BUG in RODBC with OS X?"

2005 Mar 28
0
RODBC and 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:
2007 Mar 20
1
odbcConnect - no data source and default driver
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
2005 Oct 29
2
RODBC Error
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
2006 Mar 07
2
RODBC fail install
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
2016 Jun 20
4
RODBC on Mac & _R_CHECK_FORCE_SUGGESTS_
"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.
2005 Mar 12
2
RODBC, IODBC and Mac OS X
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 ,
2011 Nov 25
1
Help for RODBC usage on mac
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 --
2005 Oct 04
1
IODBC instead of UNIXODBC
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:
2001 Jun 22
4
RODBC
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
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
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:
2002 Jan 11
1
RODBC finding dsn information using OpenLink iODBC drivers
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
2003 Oct 15
1
RODBC on Mac OSX pointers?
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: >
2005 Jun 15
2
Reading Excel files...Error
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
2006 Mar 06
1
JGR doesn't launch after updating to R 2.2.1
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:
2005 May 11
0
RODBC Oracle and VB automation with R(D)COM
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
2005 Feb 01
1
RODBC - connect is failing
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.
2006 Feb 02
3
Strange SQL Server error
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:
2002 Oct 30
1
RODBC update
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
2002 Oct 30
1
RODBC update
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
2002 Jan 25
1
RODBC, Apache, Linux
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