Neil Best wrote:
Neil Best wrote:
Does anyone know if it's possible?
I said: ./configure --with-odbc=/usr/include/w32api
It doesn't seem possible, so I am resigned to making it work in the FWTools
DOS shell. Is it possible to make a DSN-less ODBC connection? In other
words, can I specify my data source on the fly without having to go through
the ODBC Administrator and setting up every single Access file as a DSN?
Something along the lines of:
ODBC:"Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\somepath\mydb.mdb;"
(Lifted from
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForAccess )
Otherwise I'll have to write something in Perl using Win32::ODBC to loop
through all of my Access files and set up a DSN for each one.
Neil,
I have reviewed the current OGR ODBC driver and it does not seem to be
possible to pass in datasource names of the form you suggest though it is
vaguely possible that some appropriate magic quoting might get it to work.
I will say that the PGeo driver internally uses exactly this form to
access .mdb files through the same underlying ODBC machinery without
creating a DSN. So at most the OGR ODBC driver would need some adjustments
to support it.
I will take a crack at this today, and if it I get it working I'll push out
a new FWTools release with the support.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmer...@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
