julia.jacobson at arcor.de
2012-Apr-25 15:03 UTC
[R] RODBC Error Code 202 on Mac OS X 10.6
Hello everybody out there using the RODBC package, On my linux (unixODBC) and windows machines, I can successfully use the RODBC package to connect to a PostgreSQL databse. On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the error "code 202" and message "?????" when I try to establish an connection by using>con <- odbcConnect(dsn="MyDataSource",UID="Me",pwd="secret")Could anyone please hint me towards additional diagnostics I can run to pin down the problem? I have the latest versions of unixODBC and psqlODBC installed from Macports. They seem to be okay, because $isql dsn uid pwd works fine to connect to the database. Thanks in advance for your help, Julia
On Apr 25, 2012, at 10:03 AM, julia.jacobson at arcor.de wrote:> Hello everybody out there using the RODBC package, > > On my linux (unixODBC) and windows machines, I can successfully use the RODBC package to connect to a PostgreSQL databse. > On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the error "code 202" and message "?????" when I try to establish an connection by using >> con <- odbcConnect(dsn="MyDataSource",UID="Me",pwd="secret") > Could anyone please hint me towards additional diagnostics I can run to pin down the problem? > I have the latest versions of unixODBC and psqlODBC installed from Macports. > They seem to be okay, because > $isql dsn uid pwd > works fine to connect to the database. > > Thanks in advance for your help, > JuliaAnytime Fink or MacPorts comes into the picture, I get uncontrollable shakes...never had good luck with them when I moved to OSX from Linux three years ago and they really screwed up my MacBook Pro, conflicting with all kinds of stuff. If I needed something, I always go to the upstream source. I can't seem to locate an error code 202 in any ODBC documentation. Is the above a direct copy and paste of the _complete_ error message? That being said, do you know if the MacPorts installs are 32 bit, 64 bit or both? The entire tool chain, including unixODBC, the ODBC driver and R must all be of the same architecture, or you get conflicts. Check to see which version of R you are running by using: .Machine$sizeof.pointer If it comes back with 8, you are running 64 bit R, if 4, then 32 bit R. Runnning: vignette("RODBC") will bring up additional installation and other relevant details on using RODBC, including pointers to Actual Technologies: http://www.actualtech.com/products.php which provides relatively inexpensive commercial ODBC drivers for OSX and which is what I use to access Oracle on OSX, using RODBC. You would want: http://www.actualtech.com/product_opensourcedatabases.php They are easy to install and configure and also provide the ODBC Manager app, which replaces the no longer included Apple ODBC Administrator app. Also, you should post this query (now follow ups) to R-SIG-DB, as that list is focused on DB access related issues: https://stat.ethz.ch/mailman/listinfo/r-sig-db Regards, Marc Schwartz
julia.jacobson at arcor.de
2012-Apr-26 08:59 UTC
[R] RODBC Error Code 202 on Mac OS X 10.6
I thought that maybe installing the RODBC package from source might fix the problem: install.packages("RODBC",type="source") but to no success. RODBC still gives the same warning with the same error code and very little information to tackle the problem.> On Apr 25, 2012, at 10:03 AM, julia.jacobson at arcor.de wrote: > > > Hello everybody out there using the RODBC package, > > > > On my linux (unixODBC) and windows machines, I can successfully use the > RODBC package to connect to a PostgreSQL databse. > > On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the > error "code 202" and message "?????" when I try to establish an connection > by using > >> con <- odbcConnect(dsn="MyDataSource",UID="Me",pwd="secret") > > Could anyone please hint me towards additional diagnostics I can run to > pin down the problem? > > I have the latest versions of unixODBC and psqlODBC installed from > Macports. > > They seem to be okay, because > > $isql dsn uid pwd > > works fine to connect to the database. > > > > Thanks in advance for your help, > > Julia > > > Anytime Fink or MacPorts comes into the picture, I get uncontrollable > shakes...never had good luck with them when I moved to OSX from Linux three > years ago and they really screwed up my MacBook Pro, conflicting with all > kinds of stuff. If I needed something, I always go to the upstream source. > > I can't seem to locate an error code 202 in any ODBC documentation. Is the > above a direct copy and paste of the _complete_ error message? > > That being said, do you know if the MacPorts installs are 32 bit, 64 bit or > both? The entire tool chain, including unixODBC, the ODBC driver and R must > all be of the same architecture, or you get conflicts. Check to see which > version of R you are running by using: > > .Machine$sizeof.pointer > > If it comes back with 8, you are running 64 bit R, if 4, then 32 bit R. > > Runnning: > > vignette("RODBC") > > will bring up additional installation and other relevant details on using > RODBC, including pointers to Actual Technologies: > > http://www.actualtech.com/products.php > > which provides relatively inexpensive commercial ODBC drivers for OSX and > which is what I use to access Oracle on OSX, using RODBC. You would want: > > http://www.actualtech.com/product_opensourcedatabases.php > > They are easy to install and configure and also provide the ODBC Manager > app, which replaces the no longer included Apple ODBC Administrator app. > > Also, you should post this query (now follow ups) to R-SIG-DB, as that list > is focused on DB access related issues: > > https://stat.ethz.ch/mailman/listinfo/r-sig-db > > Regards, > > Marc Schwartz > >
julia.jacobson at arcor.de
2012-Apr-29 14:08 UTC
[R] RODBC Error Code 202 on Mac OS X 10.6
Unfortunately, I'm not really making any progresses, despite a lot of effort. I've compiled R on Mac OS X for myself using MacPorts and the error is now "state 28000, code 201" which is failed password authentification.