R help - Oct 2006 - Problem with RODBC

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.

Thanks in advance for any help.

Christian Hager
	[[alternative HTML version deleted]]

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

No all queries are finished.