Opened 13 years ago

Closed 3 years ago

#2725 closed enhancement (wontfix)

PGeo dsn username password

Reported by: jesper247 Owned by: warmerdam
Priority: normal Milestone: closed_because_of_github_migration
Component: OGR_SF Version: unspecified
Severity: normal Keywords: pgeo dsn userid password
Cc:

Description

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

Attachments (1)

ogrpgeodatasource.cpp.patch (3.1 KB) - added by Even Rouault 13 years ago.
Split out userid, password and DSN.

Download all attachments as: .zip

Change History (4)

comment:1 Changed 13 years ago by jesper247

Summary: PGeo ODBC username passwordPGeo dsn username password

comment:2 Changed 13 years ago by Even Rouault

Keywords: pgeo dsn userid password added

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 ?

Changed 13 years ago by Even Rouault

Attachment: ogrpgeodatasource.cpp.patch added

Split out userid, password and DSN.

comment:3 Changed 3 years ago by Even Rouault

Milestone: closed_because_of_github_migration
Resolution: wontfix
Status: newclosed

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.

Note: See TracTickets for help on using tickets.