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]]
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?: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] De la part de Bernhard Wellh?fer Envoy??: vendredi 6 juillet 2007 11:45 ??: r-help at 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][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]] ______________________________________________ R-help at stat.math.ethz.ch 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.
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.