[R] RODBC - connect is failing
Prof Brian Ripley
ripley at stats.ox.ac.uk
Tue Feb 1 22:10:21 CET 2005
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.
>
> LibMySQL.dll is in about a 1/2 dozen directories including
> Winnt\System32, my PHP directory, and several MySQL directories.
> I note that there are apparently different versions of this file
> (different file sizes and dates) so I'm not sure if there is a problem
> here.
>
> I've searched the archives and found nothing other than a suggestion
> to put the dll in the \system32 directory which didn't help. If I
> missed the key posting, just point me in the right direction and I'll
> go get the info.
>
> Not sure where to go from here so any pointers are appreciated.
>
> Doug
>
> ps - the ODBC driver is working - I can test if from the Windows
> Control Panel and get a successful connect.
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
--
Brian D. Ripley, ripley at stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595
More information about the R-help
mailing list