[mapserver-users] OGR ODBC Layer with Password

[Donald Kerr]

Jeff,

I've tried all the combinations that I can think of and the following also
works (creates test.png with the map & features) outside of mapserver on the
command line:

shp2img -m my.map -o test.png

with:

CONNECTION "ODBC:Admin/MyPassword at MyDSNName,MyTableName"

in the map file.

The following two also work:

CONNECTION "ODBC: /MyPassword at MyDSNName,MyTableName"
CONNECTION "ODBC: /MyPassword at MyDSNName"

...but no joy with MapServer.

I've tried combinations of ' and "" - no luck.

Many thanks.

Regards,

Donald


-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Jeff McKenna
Sent: 17 December 2013 20:47
To: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] OGR ODBC Layer with Password

On 2013-12-17 4:41 PM, Donald Kerr wrote:
> Jeff,
> 
> Same password error, I'm afraid. It's as if MapServer is not passing 
> the username/password combination.
> 
> Many thanks.
> 
> Regards,
> 
> Donald
> 

I've been here before.  Did you create a "System" DSN on Windows?

Then I usually look into the slash (Admin/MyPassword), and I also might
debug using single/double quotes (all usual Windows debugging joy).

-jeff




--
Jeff McKenna
MapServer Consulting and Training Services http://www.gatewaygeomatics.com/


_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4259 / Virus Database: 3658/6928 - Release Date: 12/17/13