[gdal-dev] OGRinfo works, but a MapServer test mode=map DOES NOT

[Eduardo Kanegae]

Hi all,

I´m running Windows Server 2008 R2 Enterprise SP1 64bits using MS4W
3.0.1 with MapServer CGI 5.6.6 grabed from MapTools.org
My spatial data is on SQL Server 2008 + MsSqlSpatial 0.1.1 Lib and
I´ve set an ODBC DSN connection using SQL Server Native Driver 10
( using Control Panel -> ODBC Admin -> System DSN and also
C:\Windows\SysWOW64\odbcad32.exe tool )

When I run ogrinfo using:
$ ogrinfo -so "MSSQL:dsn=my_dsn;server=(local);database=my_database;tables=dbo.my_table;uid=my_user;pwd=my_passwd"
my_table

it works and dumps info like:
...
INFO: Open of `MSSQL:dsn=nucoffee;server=(local);database=nucoffee;tables=dbo.fazendas2;uid=db_nucoffee;pwd=@&NuCoFfEe&@'
      using driver `MSSQLSpatial' successful.
... and so on!

BUT, when trying a MapServer CGI mode map request like:
http://my_server/cgi-bin/mapserv.exe?map=e:/my_mapfile.map&mode=map&layers=all&map_size=800+600
I only got the error:

msDrawMap(): Image handling error. Failed to draw layer named
'pol_my_layer'. msOGRFileOpen(): OGR error. Open failed for OGR
connection in layer `pol_my_layer'. Unable to initialize ODBC
connection to DSN for my_user/my_passwd at my_dsn, [Microsoft][ODBC
Driver Manager] Data source name not found and no default driver
specified

Can anybody give me a clue on that?

My LAYER mapfile part is defined as :

**********************
LAYER		
		NAME			"pol_my_layer"
		TYPE			POLYGON		
		CONNECTIONTYPE OGR
		CONNECTION "<OGRVRTDataSource>
    <OGRVRTLayer name='pol_my_layer'>
		<SrcDataSource>ODBC:my_user/my_passwd at my_dsn</SrcDataSource>
		<SrcLayer>dbo.vw_pol_my_spatial_view</SrcLayer>
		<LayerSRS>WGS84</LayerSRS>
		<GeometryType>wkbUnknown</GeometryType>
		<GeometryField encoding='WKB' field='geom_2005'/>
    </OGRVRTLayer>
</OGRVRTDataSource>"
		DATA "pol_my_layer"
		FILTER "329"
		FILTERITEM "farm_id"
		PROCESSING "CLOSE_CONNECTION=DEFER"
	END
	...
END
**********************

best regards,

--
Eduardo Patto Kanegae