[R-sig-Geo] rgdal and MSSQL Server geometries

[cmundy]

Hi Shannon,

I can recreate your error message when I set an incorrect dsn. I've pasted
in your line of code to read from SQL Server. Can you replace the single
quote with double quotes and re try as is.
check your server and database name.

readOGR(dsn='MSSQL:server=CPU\\CPU_SQL2012EXP;database=Deer;uid=myUser;trusted_connection=true',
layer='CollarPoly')

>From the line provided, I gather your computer name is CPU and the SQL
server instance is called CPU_SQL2012EXP. Can you confirm these two names
and the database name are correct.

Regards

Craig



--
View this message in context: http://r-sig-geo.2731867.n2.nabble.com/rgdal-and-MSSQL-Server-geometries-tp7583193p7583220.html
Sent from the R-sig-geo mailing list archive at Nabble.com.