Re: [R] Problem with RODBC

From: Jerome Asselin <>
Date: Fri 27 Oct 2006 - 16:49:19 GMT

On Fri, 2006-10-27 at 14:30 +0200, Christian Hager wrote:
> Hello,
> I'am currently experiencing some problems with the odbcCloseAll() and
> odbcClose() function. I'm trying to connect an R script to a MySQL 5.0
> database using RODBC1.1-7 and the MySQL ODBC Driver v.3.51 on a
> Windows XP Machine. At first everything seems fine. The script
> connects, reads and writes data but when it comes to odbcCloseAll() it
> crashes and hangs forever. Unfortunately I haven't been able to find
> out why yet. So I was hoping someone here could point me to what the
> problem might be.

Perhaps MySQL is still busy with some query when you try closing the connection. Can you check whether MySQL is still running query?


Jerome Asselin, M.Sc., Agent de recherche, RHCE
CHUM -- Centre de recherche
3875 rue St-Urbain, 3e etage // Montreal QC  H2W 1V1
Tel.: 514-890-8000 Poste 15914; Fax: 514-412-7106

______________________________________________ mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.
Received on Sat Oct 28 02:59:55 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 27 Oct 2006 - 17:30:12 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.