Issue to obtain data from SQL Server in spanish


#1

I have a SQL Server database, in spanish, and I want to obtain the results from SELECT * table.name

To do this, I connect R with the database using odbc library.

After that, I do this:

dbSendQuery(con,"SELECT * FROM [database].[dbo].[table.name]")

This returns me an error: std::bad_alloc

But if I do this:

dbSendQuery(con,"SELECT Id FROM [database].[dbo].[table.name]")

then I obtain good resutls

I have seen that only when varchar type of columsn names are involved in the query, then the error is shown, so I think that schema could be the responsible of this issue.

What can I do to dont have this error? The schema is “dbo”

Thanks!


#2

Maybe the resolution for this issue can help: https://github.com/r-dbi/odbc/issues/153