Problem with RODBC
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