[R] Problems Building RMySQL in Windows

["Héctor Villafuerte D."]

Hi all,
Unfortunately I must use winXP at my job, so I'm trying install
from source RMySQL. Here are some details about this problem:
- R 1.7.1
- RMySQL 0.5-2
- mysql  4.1.0-alpha-max-nt
I followed the instructions posted in 
http://www.biostat.jhsph.edu/~kbroman/Rintro/Rwinpack.html
and the following messages appeared. BTW, thanks in advance for your 
help and comments.


C:\Program Files\R\rw1071\src\gnuwin32>make pkg-RMySQL

---------- Making package RMySQL ------------

   **********************************************
   WARNING: this package has a configure script
         It probably needs manual configuration
   **********************************************

  installing inst files
  adding build stamp to DESCRIPTION
  making DLL ...
making RS-DBI.d from RS-DBI.c
making RS-MySQL.d from RS-MySQL.c
gcc  -Ic:/mysql/include  -IC:/PROGRA~1/R/rw1071/src/include -Wall -O2   
-c RS-DBI.c -o RS-DBI.o
gcc  -Ic:/mysql/include  -IC:/PROGRA~1/R/rw1071/src/include -Wall -O2   
-c RS-MySQL.c -o RS-MySQL.o
ar cr RMySQL.a *.o
ranlib RMySQL.a
windres --include-dir C:/PROGRA~1/R/rw1071/src/include  -i RMySQL_res.rc 
-o RMySQL_res.o
gcc  --shared -s  -o RMySQL.dll RMySQL.def RMySQL.a RMySQL_res.o  
-LC:/PROGRA~1/R/rw1071/src/gnuwin32 -Lc:/mysql/lib/opt
 -lmysql -liberty -lg2c -lR
RMySQL.a(RS-MySQL.o)(.text+0x216):RS-MySQL.c: undefined reference to 
`_mysql_get_client_info'
RMySQL.a(RS-MySQL.o)(.text+0x7f9):RS-MySQL.c: undefined reference to 
`_mysql_init'
RMySQL.a(RS-MySQL.o)(.text+0x817):RS-MySQL.c: undefined reference to 
`_mysql_options'
RMySQL.a(RS-MySQL.o)(.text+0x879):RS-MySQL.c: undefined reference to 
`_mysql_options'
RMySQL.a(RS-MySQL.o)(.text+0x8e4):RS-MySQL.c: undefined reference to 
`_load_defaults'
RMySQL.a(RS-MySQL.o)(.text+0xb39):RS-MySQL.c: undefined reference to 
`_mysql_real_connect'
RMySQL.a(RS-MySQL.o)(.text+0xc3d):RS-MySQL.c: undefined reference to 
`_mysql_close'
RMySQL.a(RS-MySQL.o)(.text+0xd31):RS-MySQL.c: undefined reference to 
`_mysql_options'
RMySQL.a(RS-MySQL.o)(.text+0xde1):RS-MySQL.c: undefined reference to 
`_mysql_close'
RMySQL.a(RS-MySQL.o)(.text+0xf89):RS-MySQL.c: undefined reference to 
`_mysql_query'
RMySQL.a(RS-MySQL.o)(.text+0xfa4):RS-MySQL.c: undefined reference to 
`_mysql_use_result'
RMySQL.a(RS-MySQL.o)(.text+0xfbe):RS-MySQL.c: undefined reference to 
`_mysql_field_count'
RMySQL.a(RS-MySQL.o)(.text+0x106a):RS-MySQL.c: undefined reference to 
`_mysql_affected_rows'
RMySQL.a(RS-MySQL.o)(.text+0x10de):RS-MySQL.c: undefined reference to 
`_mysql_error'
RMySQL.a(RS-MySQL.o)(.text+0x116f):RS-MySQL.c: undefined reference to 
`_mysql_fetch_fields'
RMySQL.a(RS-MySQL.o)(.text+0x1188):RS-MySQL.c: undefined reference to 
`_mysql_field_count'
RMySQL.a(RS-MySQL.o)(.text+0x155c):RS-MySQL.c: undefined reference to 
`_mysql_fetch_row'
RMySQL.a(RS-MySQL.o)(.text+0x1576):RS-MySQL.c: undefined reference to 
`_mysql_fetch_lengths'
RMySQL.a(RS-MySQL.o)(.text+0x17c3):RS-MySQL.c: undefined reference to 
`_mysql_errno'
RMySQL.a(RS-MySQL.o)(.text+0x19e4):RS-MySQL.c: undefined reference to 
`_mysql_errno'
RMySQL.a(RS-MySQL.o)(.text+0x19ef):RS-MySQL.c: undefined reference to 
`_mysql_error'
RMySQL.a(RS-MySQL.o)(.text+0x1a64):RS-MySQL.c: undefined reference to 
`_mysql_fetch_row'
RMySQL.a(RS-MySQL.o)(.text+0x1a74):RS-MySQL.c: undefined reference to 
`_mysql_free_result'
RMySQL.a(RS-MySQL.o)(.text+0x1d1b):RS-MySQL.c: undefined reference to 
`_mysql_get_client_info'
RMySQL.a(RS-MySQL.o)(.text+0x1f4e):RS-MySQL.c: undefined reference to 
`_mysql_get_host_info'
RMySQL.a(RS-MySQL.o)(.text+0x1f78):RS-MySQL.c: undefined reference to 
`_mysql_get_server_info'
RMySQL.a(RS-MySQL.o)(.text+0x1fa5):RS-MySQL.c: undefined reference to 
`_mysql_get_proto_info'
RMySQL.a(RS-MySQL.o)(.text+0x1fb6):RS-MySQL.c: undefined reference to 
`_mysql_thread_id'
RMySQL.a(RS-MySQL.o)(.text+0x2c32):RS-MySQL.c: undefined reference to 
`_mysql_fetch_lengths'
RMySQL.a(RS-MySQL.o)(.text+0x2c59):RS-MySQL.c: undefined reference to 
`_mysql_errno'
RMySQL.a(RS-MySQL.o)(.text+0x2eda):RS-MySQL.c: undefined reference to 
`_mysql_fetch_row'
collect2: ld returned 1 exit status
make[2]: *** [RMySQL.dll] Error 1
make[1]: *** [src/RMySQL.dll] Error 2
make: *** [pkg-RMySQL] Error 2

C:\Program Files\R\rw1071\src\gnuwin32>