Re: [R] Problem with RODBC

From: Jerome Asselin <jerome.asselin_at_crchum.qc.ca>
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

-- 
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

______________________________________________
R-help@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
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 https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.