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 <[EMAIL PROTECTED]> 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. > > ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
