[R-sig-DB] [R] RODBC Error Code 202 on Mac OS X 10.6

[juii@@j@cobso@ m@iii@g oii @rcor@de]

Finally, I found the core of the problem: If I use a password without special characters, I can odbcConnect from within R on Mac OS X. So it's really a matter of the encoding.
Since I would like to use strong passwords with special characters I would be very grateful  for any hints on how to fix the encoding, because there are several places where I can set it: The PostgreSQL DBMS itself, in the psqlODBC driver, in the RODBC package in finally in R itselft.

> When trying to further investigate, whether it makes a differences to use
> the 64 bit version of R on Mac OS X or the 32 bit one, I got a different
> error message on the 32 bit version:
> [RODBC] FEHLER: Status IM003, Code -1073759164, Nachricht [iODBC][Driver
> Manager]Specified driver could not be loaded
> RODBC is obviously trying to use the wrong ODBC setup here: I use unixODBC
> and not iODBC for connecting to the database with other programs on my Mac.
> Could it perhaps be that also the 64 bit version, which does however return
> the error message mentioned in the title of this thread use iODBC instead of
> unixODBC? Is there a way to force the usage of unixODBC in RODBC?
> 
> > I cannot help you if this really is a Mac issue, but the error message 
> > sounds to me like your server is not configured to accept connections 
> > from your client. When you say it works with a different OS, do you mean 
> > on the same machine, or do you mean on a machine with a different IP 
> > address?  If the latter, then be sure the server has the same 
> > permissions for the two machines, then check that the odbc.ini files 
> > have the same UserName and Password settings, just in case that is 
> > really what is being used, rather than the strings in the command line. 
> > You should also be sure the host server setting is the same on both 
> > machines, just in case you happen to be talking to different servers.
> > 
> > (I do realize that you probably know this, but it is surprisingly 
> > difficult to get these right, and the error message you get when they 
> > are wrong is the one you are getting.)
> > 
> > Another thing you can do is to run the server in debug mode, which 
> > sometimes gives better details about attempted connection failures.
> > 
> > Paul
> > 
> > On 12-05-27 03:39 PM, julia.jacobson using 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
> > >
> > >> 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.
> > >
> > > Interestingly, I was able to set up RODBC on Mac OS X 10.4 (PowerPC
> > architecture) successfully and as I said, it does work on Linux and
> Windows
> > XP/7 perfectly.
> > > I was wondering whether the undecipherable error message I get on OS X
> > 10.6 is due to wrong encoding settings on my machine in relation to the
> ones
> > on the server. It would already be of great help to be able to read the
> > error message.
> > > It is probably a problem of the versions of the OS, psqlODBC, R and
> RODBC
> > on my machine.
> > > It would be great to get feedback from someone running Mac OS X 10.6 in
> > combination with RODBC successfully and check for the differences with my
> > setup.
> > >
> > > _______________________________________________
> > > R-sig-DB mailing list -- R Special Interest Group
> > > R-sig-DB using r-project.org
> > > https://stat.ethz.ch/mailman/listinfo/r-sig-db
> >
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>