I'm trying to connect to a SQL server database from R. The database is read only, will I still be able to do that? I have tried the following code, but it's not working for some reason.
it is perfectly normal to connect to databases with only read access. In fact you probably do not wish for a write access to a production dabatase; knowing you can not break anything come what may is kind of liberating
The approach you are taking is in princple a correct one, but you do not give us enough information to help. What error message do you get? Have you loaded all libraries required? dbConnect is from {DBI} and odbc from {odbc}.