Hello, i have problem with the following code (I'm using sqlQuery function from RODBC package): eval(parse(text="g_1 <- sqlQuery(cnn_1, \"select aa from bb.[cc\\dd].ee\")")).
I get the error message: "[RODBC] ERROR: Could not SQLExecDirect" "S0002 208 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'bb.cc\dd.ee'." It seems that R is replacing square brackets that are needed for database to execute query. How can I force R to change its behavior and leave square brackets unchanged? Any ideas appreciated. Kuba ______________________________________________ R-help@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.
