I would like to import an esri Personal Geodatabase (.mdb) to PostGIS. I have tried to follow the blog post:
How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux
I installed the GDAL tool suite (using gdal-110-1600-x64-core.msi), but whenever I try to run ogr2ogr
, I get the following error:
ogr2ogr -f "PostgreSQL" PG:"host=localhost user=penusr dbname=my_pg_db password=my_pg_db_pass port=5432" C:\data\PROVINCES_2013.mdb -a_srs EPSG:26986
ERROR 1: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\data\PROVINCES_20
13.mdb,
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
FAILURE:
Unable to open datasource C:\data\PROVINCES_2013.mdb' with the following drivers.
-> ESRI Shapefile
-> PostgreSQL
... list of many more.
Does this error typically indicate a problem with connecting to my Postgre DB, or something else? Am I missing some settings? I am fairly sure that the dbname and password are correct.
If I go to the ODBC Data Source Administrator window, I can see that under the Drivers tab PostgreSQL ANSI(x64) and PostgreSQL Unicode(x64) are listed.
ogrinfo C:\data\PROVINCES_2013.mdb
?