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

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

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
>