Hi mdsumner Many thanks for your answer. The additional arguments in odbcDriverConnect did not change the problem. The error message remained the same. However, I did manage to successfully read a table using the odbc package. Thanks for the suggestion! The following code did work: ########## dstring <- "DRIVER={Manifold 9.0 Project Driver (*.map)};DBQ=E:\test.map;Unicode=True;Ansi=False;OpenGIS=True;DSN=Default;" con <- dbConnect(odbc::odbc(), .connection_string = dstring) dbListTables(con) dbReadTable(con, "geocoded") dbGetQuery(con, "SELECT * FROM geocoded") ########### Regarding the geometry column, it returns something like "blob[413 B]", and I'm not sure how to use it. However, if I transform the geometry to WKT using GeomWkt in the manifold query, I get a usable output. Anyway, I'm not particularly interested in the geometry column in R. I just want to retrieve the data in R to be able to draw some plots/graphs, but I'll stick to manifold for the GIS stuff. Out of curiosity, I also tried the sf::read_sf. It works, but I get an error with the geometry column In CPL_read_ogr(dsn, layer, query, as.character(options), ... : GDAL Error 1: GetNextRawFeature(): Corrupt data Which then return an empty geometrycollection. As I said, it was just out of curiosity, since I'm not particularly interested in the geometry column. Thanks again for your answer, it really helped!
|