Re: [R] R brakes when submitting a query to MySQL

2007-12-18 Thread Marc Moragues
AppVer: 2.60.43063.0ModName: msvcrt.dll ModVer: 7.0.2600.2180Offset: 000378c0 Marc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zembower, Kevin Sent: 18 December 2007 18:18 To: r-help@r-project.org Subject: Re: [R] R brakes when submitting a query to

Re: [R] R brakes when submitting a query to MySQL

2007-12-18 Thread Emmanuel Charpentier
Marc Moragues a écrit : > Hello, > > I would like to retrieve data stored in MySQL database, so I installed > RMySQL package. > I can successfully connect with the my database using the following code > >> dvr<-dbDriver("MySQL") >> con2<-dbConnect(dvr,group="exbardiv") >> mysqlDescribeConnection(

Re: [R] R brakes when submitting a query to MySQL

2007-12-18 Thread Zembower, Kevin
Is it your use of 'con' rather than 'con2' in dbSendQuery? -Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Moragues Sent: Tuesday, December 18, 2007 1:14 PM To: r-help@r-project.org Subject: [R] R brakes when submitting a q

[R] R brakes when submitting a query to MySQL

2007-12-18 Thread Marc Moragues
Hello, I would like to retrieve data stored in MySQL database, so I installed RMySQL package. I can successfully connect with the my database using the following code > dvr<-dbDriver("MySQL") > con2<-dbConnect(dvr,group="exbardiv") > mysqlDescribeConnection(con2) User: mmorag Host: localh