Did you read the ReadMe in the download area, or the rw-FAQ? Please do
so, and don't send bug reports on contributed packages you have not
compiled yourself.
Let me give you a hint: the rw1062 version is comnpiled for MySQL 3.x
and the rw1070 version for MySQL 4.0: AS IT SAYS in the INSTALL.win file.
The client DLLs do not interwork, so there is no way both could work on
the same machine.
Now, do you understand how annoying you have been?
On Thu, 24 Apr 2003, Philippe Grosjean wrote:
> Hi,
>
> I was able to connect to a MySQL database (called "zooscan" and
with a table
> "serie" under Win XP with R 1.6.2 using:
>
> > library(DBI)
> > library(RMySQL)
> Warning message:
> DLL attempted to change FPU control word from 8001f to 9001f
> > drv <- dbDriver("MySQL")
> > con <- dbConnect(drv, dbname="zooscan")
> > dbExistsTable(con, "serie")
> [1] TRUE
> > dbDisconnect(con)
> [1] TRUE
>
> Notice the warning message, but apparently without other incidence.
>
> Now, when I try this with R 1.7.0, R crashes at the line:
> > con <- dbConnect(drv, dbname="zooscan")
>
> with the error report containing:
> AppName: rgui.exe AppVer: 1.70.30416.0 ModName: msvcrt.dll
> ModVer: 7.0.2600.0 Offser: 00033730
>
> indicating that the error occurs in a call to msvcrt.dll, which is the
> following:
> msvcrt.dll
> Image Base: 0x77c10000 Image Size: 0x00053000
> CheckSum: 0x00055a85 Time Stamp: 0x3b7dfe0e
> Version Information
> Signature: feef04bd
> StrucVer: 000100000
> FileVer: (7.0:2600.0)
> ProdVer: (6.1:8638.0)
> FlagMask: 0000003f
> Flags: 00000000
> OS: 00040004
> FileType: 00000001
> SubType: 00000000
> FileDate: 00000000:00000000
>
> I have also:
> > version
> platform i386-pc-mingw32
> arch i386
> os mingw32
> system i386, mingw32
> status
> major 1
> minor 7.0
> year 2003
> month 04
> day 16
> language R
>
> and:
> C:\Program Files\\mysql\bin>mysqladmin --user=root version
> mysqladmin Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 3.23.49-max-nt
> Protocol version 10
> Connection . via named pipe
> UNIX socket MySQL
> Uptime: 2 hours 7 min 30 sec
>
> Threads: 1 Questions: 18 Slow queries: 0 Opens: 6 Flush tables: 1 Open
> tabl
> es: 0 Queries per second avg: 0.002
>
>
>
>
> Notice also that I've got the same crash in R 1.7.0 under Windows 98
using:
> > ....
> > con <- dbConnect(drv, dbname="zooscan", port=3306)
>
> I tested this on various machines with either Win XP or Win 98, and it
> consistently succeed in R 1.6.2 and crashes in R 1.7.0. So, it seems that
> some changes made in R itself is involved. By the way, do I have to
> recompile RMySQL for R 1.7.0 (I used the compiled version on CRAN at
> /windows/contrib/1.7).
> Best,
>
> Philippe Grosjean
>
>
...........]<(({?<...............<?}))><...............................
> ) ) ) ) )
> ( ( ( ( ( Dr. Philippe Grosjean
> ) ) ) ) )
> ( ( ( ( ( LOV, UMR 7093
> ) ) ) ) ) Station Zoologique
> ( ( ( ( ( Observatoire Oc?anologique
> ) ) ) ) ) BP 28
> ( ( ( ( ( 06234 Villefranche sur mer cedex
> ) ) ) ) ) France
> ( ( ( ( (
> ) ) ) ) ) tel: +33.4.93.76.38.18, fax: +33.4.93.76.38.34
> ( ( ( ( (
> ) ) ) ) ) e-mail: phgrosjean at sciviews.org
> ( ( ( ( ( SciViews project coordinator (http://www.sciviews.org)
> ) ) ) ) )
> .......................................................................
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
>
--
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