Discussion:
[Qgis-user] Working with ESRI mdb geodatabase file
Piotr Pachół
2010-03-03 16:28:54 UTC
Permalink
Hello,
I have ESRI mdb geodatabase file.
How can I create a database connection to this file ?
When I try to use option: "Add vector layer/Create database
connection/ESRI Personal Geodatabase"
I have an error: "Unable to initialize ODBC connection to DSN"

So what should fill in connection information ? (host, database, port)
Where I can fill in full path with name and extension of file ?

Piotr
Werner Macho
2010-03-03 16:34:10 UTC
Permalink
hi Piotr!

regarding to this post
http://www.mail-archive.com/qgis-***@lists.osgeo.org/msg00597.html
you should be at least able to use GDAL to convert your mdb in a QGIS
readable format..

regards
Werner
Post by Piotr Pachół
Hello,
I have ESRI mdb geodatabase file.
How can I create a database connection to this file ?
When I try to use option: "Add vector layer/Create database
connection/ESRI Personal Geodatabase"
I have an error: "Unable to initialize ODBC connection to DSN"
So what should fill in connection information ? (host, database, port)
Where I can fill in full path with name and extension of file ?
Piotr
_______________________________________________
Qgis-user mailing list
http://lists.osgeo.org/mailman/listinfo/qgis-user
G. Allegri
2010-03-03 16:36:55 UTC
Permalink
If you're working on Windows you should first create an ODBC
connection through Administrative Tools.

giovanni
Post by Werner Macho
hi Piotr!
regarding to this post
you should be at least able to use GDAL to convert your mdb in a QGIS
readable format..
regards
Werner
Post by Piotr Pachół
Hello,
I have ESRI mdb geodatabase file.
How can I create a database connection to this file ?
When I try to use option: "Add vector layer/Create database
connection/ESRI Personal Geodatabase"
I have an error: "Unable to initialize ODBC connection to DSN"
So what should ?fill in connection information ? (host, database, port)
Where I can fill in full path with name and extension of file ?
Piotr
_______________________________________________
Qgis-user mailing list
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
http://lists.osgeo.org/mailman/listinfo/qgis-user
Piotr Pachół
2010-03-03 17:09:42 UTC
Permalink
Thanks, it is working !
But one question: is it possible to display coded value domains which I
have defined in mdb file ?
Piotr
Post by G. Allegri
If you're working on Windows you should first create an ODBC
connection through Administrative Tools.
giovanni
Hello,
Post by Piotr Pachół
I have ESRI mdb geodatabase file.
How can I create a database connection to this file ?
When I try to use option: "Add vector layer/Create database
connection/ESRI Personal Geodatabase"
I have an error: "Unable to initialize ODBC connection to DSN"
So what should fill in connection information ? (host, database, port)
Where I can fill in full path with name and extension of file ?
Piotr
_______________________________________________
Qgis-user mailing list
http://lists.osgeo.org/mailman/listinfo/qgis-user
G. Allegri
2010-03-03 17:22:32 UTC
Permalink
I don't know because I rearely use gdb from OS software, but I don't
think. The domains are set using relations between domain and data
tables internally the mdb, I don't think the ogr driver follow this
relations to retrieve the domain values. You could:

- save the mdb with the substituted values, e.g. from a query where
you ask for the joined coded values <-> domains values
- export the domains table from the mdb as dbf and use the Ftools
plugin to join it to the features attribute table.

giovanni
Post by Piotr Pachół
Thanks, it is working !
But one question: is it possible to display coded value domains which I have
defined in mdb file ?
Piotr
Post by G. Allegri
If you're working on Windows you should first create an ODBC
connection through Administrative Tools.
giovanni
?Hello,
Post by Piotr Pachół
I have ESRI mdb geodatabase file.
How can I create a database connection to this file ?
When I try to use option: "Add vector layer/Create database
connection/ESRI Personal Geodatabase"
I have an error: "Unable to initialize ODBC connection to DSN"
So what should ?fill in connection information ? (host, database, port)
Where I can fill in full path with name and extension of file ?
Piotr
_______________________________________________
Qgis-user mailing list
http://lists.osgeo.org/mailman/listinfo/qgis-user
Loading...