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?
 
Regards,
 
Bernhard
 
 
 
 
 

	[[alternative HTML version deleted]]

