[R] Problem with RODBC

[Jerome Asselin]

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