I would like to import an esri Personal Geodatabase (.mdb) to PostGIS. I have tried to follow the blog post:
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.