[Qgis-user] Loading ESRI .mdb geodatabase

[Lester Anderson]

Hello Filipe,

I could not find an option in QGIS 2.6 a way of getting the database option
to work

eg. data in c:\test\esri_geodatabase\file.mdb

Create a new OGR Database connection
Type = ESRI Personal GeoDatabase
Name = MDB1
Host = C:\test\ESRI_Geodatabase
Database = file.mdb
Port = empty
Usename = empty
Password = empty

Generates an error "Unable to initialise ODBC connection to DSN for DRIVER=
Microsoft Access Driver (*.mdb); DBQ=PGeo:file.mdb, [Microsoft][OBDC Driver
Manager] Data source name not found and no default driver specified"

The "Open an OGR Supported Vector Layer" shows that ESRI Personal
Geodatabase is an option under file formats. so it is there to use. Not
sure how to get this working.

Is there a clear tutorial guide that wouldm cover this issue?

Cheers

Lester

On 24 November 2014 at 10:06, Filipe Dias <filipesdias at gmail.com> wrote:

> Hi,
>
> Have you tried Add layer -> Source type - "Database"?
>
> On Mon, Nov 24, 2014 at 10:03 AM, Lester Anderson <arctica1963 at gmail.com>
> wrote:
>
>> Hello,
>>
>> I have been trying to load an ESRI (ARcGIS 10) .mdb geodatabase but
>> cannot seem to get it to recognise it as a ESRI personal geodatabase file.
>>
>> Tried using add vector layer -> file -> ESRI Personal geodatabase format)
>> and also as a directory, both seem to fail to recognise the format.
>>
>> C:\Program Files\QGIS Brighton\bin\gdalplugins\ogr_FileGDB.dll - checked
>> the plugin
>>
>> Not sure what I am doing wrong here (2.6 windows 64-bit)
>>
>> Cheers
>> Lester
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141124/5ca57e51/attachment.html>