Displaying 1 result from an estimated 1 matches for "sjlc_info".
2007 Dec 18
2
R brakes when submitting a query to MySQL
...<MySQLConnection:(972,0)>
User: mmorag
Host: localhost
Dbname: exbardiv
Connection type: localhost via TCP/IP
No resultSet available
I can even see the tables in the database
> dbListTables(con2)
[1] "agoueb" "high_ld" "rescue" "sjlc_info" "sjlc_ld" "temp"
[7] "temp_snp1" "temp_snp2"
However, when I try to query the database, R breakes.
res<-dbSendQuery(con,'select * from sjlc_ld')
Can anyone help me tune up the connection between R and MySQL?
Thank you,
Marc.
_ _ _ _ _...