Hello,
I use a RODBC connection to a MySQL server on a Debian machine. The call to
odbcConnect() seems to be ok, but the result of the first
sqlFetch(channel,t_studie) retrieves this data frame:
[1] [RODBC] ERROR: Could not SQLExecDirect
[2] 42000 1064 [MySQL][ODBC 3.51
@stat.math.ethz.ch
Objet : [R] RODBC problem
Hello,
I use a RODBC connection to a MySQL server on a Debian machine. The call to
odbcConnect() seems to be ok, but the result of the first
sqlFetch(channel,t_studie) retrieves this data frame:
[1] [RODBC] ERROR: Could not SQLExecDirect
[2] 42000 1064 [MySQL
:59 AM
To: Bernhard Wellhöfer
Cc: r-help@stat.math.ethz.ch
Subject: RE: [R] RODBC problem
Hello,
The problem seems to be in the query syntax.
Can you show us the query you are trying to perform ?
Regards,
Cedric
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL
Hi All,
I'm using Microsoft Office 2007 Beta version and I have
one file in .xlsx format with size 168MB. How can I use odbcConnectExcel
in this as this function only supports .xls format? I have huge data
containing 603470 rows in a .csv file. Thanks in advance.
In a mdb table, I have a text field with values of 1, 2, When I
use rodbc to read it into R, it becomes numeric. Is it a bug or
something?
Thanks.
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read
On Fri, 2006-10-20 at 10:25 -0400, Wensui Liu wrote:
In a mdb table, I have a text field with values of 1, 2, When I
use rodbc to read it into R, it becomes numeric. Is it a bug or
something?
I don't think it's a bug. This behavior is documented.
See ?sqlQuery. Try the as.is=T argument.
Hi
I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows
XP Pro. I am having problems writing a new table to an (Excel) database
using sqlSave.
I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I
believe, uses the Microsoft Excel Driver DSN). Then I try and
The driver does not support writing to Excel: did you check?
On Mon, 21 Jul 2003, David Khabie-Zeitoune wrote:
Hi
I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows
XP Pro. I am having problems writing a new table to an (Excel) database
using sqlSave.
I connect to