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