Craig, that did the trick, I didn't have the correct tables/schema for gdal to
refer to. Now I can read into R, from SQL Server, data tables having a geometry
data type. Below I describe the two additional tables that one needs to create
to allow rgdal the ability to read from your SQL Server
Craig, thanks for the idea. I did create a DSN using ODBC as well as using an
explicit string connection. Both give me the same result of: 'Cannot open data
source'
Thus, I am thoroughly confused because I can connect to the SQL Server via all
of my other methods (RODBC) and software with no
Dear r-geo list,
I am potentially struggling with some syntax and thought that maybe someone has
solved a similar issue. I am trying to use 'rgdal' package and the readOGR
function to read in a data table from a MS SQL Server 2012 instance. In the
table I have a column of type 'geometry'. In