[R] RODBC - connect is failing

[Donna-n-Doug Finner]

Thank you for your reply and thanks for the 'fishing tip'.  I thought,
however, that I had debugged my setup - I tested the ODBC connection
to MySQL directly from the ODBC driver setup and connected
successfully.  If R, RODBC, and ODBC are all telling me 'life is
good', any tips on the next suspect to check?

Thanks again for the help.

Doug

Off Topic Comment:  I realize this isn't an R issue but one of the
joys (sic) of building complex systems is that any particular problem
is never any one application's fault.  I always have difficulty
finding someone who is conversant in all (heck, even most) of the
pieces of a particular puzzle to be able to help me connect the dots. 
Using my problem as an example, it may turn out the the answer is
sitting in the brain of a user on a PHP or Apache or Windows forum who
just happens to use R but doesn't hang here.  Connecting with that
person is the challenge.  I may have to scrap the
Apache/PHP/MySQL/R/Webby Thing design concept and move through a
series of smaller baby steps - R with lots of manual intervention
using text data files; R via batch processes; R via batch processes
with user Q&A actions; R via...etc etc.  I can see the end point, but
there's just a huge trackless thicket between my current possition and
the finished product and all I have is a pocket knife and a song in my
heart.
End of OT Comment.


On Tue, 1 Feb 2005 21:10:21 +0000 (GMT), Prof Brian Ripley
<ripley at stats.ox.ac.uk> wrote:
> The message is from the MySQL ODBC driver, as it indicates.
> You'll have to debug your setup, as this is not an R nor RODBC issue: the
> latter has done its job and connected to the driver.
> 
> On Tue, 1 Feb 2005, Donna-n-Doug Finner wrote:
> 
> > 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.
> >