PGeo dsn username password

[jesper247]

Hi Team

I have been trying to access a Personal Geodatabase through a DSN.

First part of my problem is that the GBD is imported into a MsSql2000 server. I solve that by accessing the data through a DSN, and by making sure that the table GDB_GeomColumns is represented. This works fine through ODBC-connections if there are no password on the database.

When the database is passwordprotected (SQL-authentication) it seems that there is no way of providing user/pass through the DSN. Therfor i was looking at the ogr-driver source, and found that in http://trac.osgeo.org/gdal/browser/trunk/gdal/ogr/ogrsf_frmts/pgeo/ogrpgeodatasource.cpp it seems that user/pass is hardcodet to NULL, NULL.:

if( !oSession.EstablishSession( pszDSN, NULL, NULL ) ) 
{ .....
}

My enhancement-request is, that we get some way of providing user/pass for the DSN used in the PGeo-driver.

Hope you will consider this enhancement.

regards Jesper

[Even Rouault]

Jesper,

I've mostly copied & pasted the code from the ODBC driver that does exactly what you want. Similar to the ODBC driver, the connection string should be "PGeo:user/password@dsn".

However I'm not in a position to test if it really works. Could you apply the attached patch and confirm that it works ?

[Even Rouault]

Split out userid, password and DSN.

[Even Rouault]

This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to ​https://github.com/OSGeo/gdal/issues if it is not already reported there.