Hi.
It looks like the letter 'e' at the end of the table name is not latinic
'e'.
sqlFetch constructs the SQL query internally from the supplied table name:
ans <- sqlQuery(channel, paste("SELECT * FROM", dbname),
...)
What will be the answer for
sqlQuery(channel, paste("SELECT * FROM", "t_studie"))
?
Or, if you should set up some settings regarding the locale on the MySQL
server (not sure, what and where exactly)
Bernhard2 wrote:
>
> 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
> Driver][mysqld-5.0.22-Debian_1bpo1-log]You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use near '\"t_studi(\004"
>
> Please note the funny character at the end of the table name in the error
> message.
>
> The "Test Data Source" option on the ODBC Data Source Name configuration
> panel report success.
>
> Who can help me here?
>
>
--
View this message in context:
http://www.nabble.com/RODBC-problem-tf4034563.html#a12898626
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
