[R] RODBC problem

[Vladimir Eremeev]

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.