[mapserver-users] Mapserver MSSQL connect

[j5c077]

Hello list,
I've been trying for a while to connect to my MSSQL spatial db with
mapserver with no luck. If anyone could provide any insight I would be very
grateful.

The mapserver error i'm getting is "Unable to initialize connection to the
server for MSSQL:server..., [unixODBC][Driver Manager]Data source name not
found, and no default driver specified"

MapServer is version 6.0.1 running on CentOS.  my layer in the mapfile is
currently set like this, though i've tried several variations based on the
info i've found searching forums in hopes of getting it working:

LAYER
	NAME "points"
	TYPE Point
	STATUS DEFAULT
	CONNECTIONTYPE OGR
	CONNECTION
'MSSQL:server=xxx.xxx.xxx.xxx,1433;database=database;uid=username;pwd=password'
	PROCESSING 'CLOSE_CONNECTION=DEFER'
	DATA "SP_GEOMETRY from points"
         CLASS
	 NAME "point"
	   STYLE
	   SYMBOL "point"
	   END
	END
END

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Mapserver-MSSQL-connect-tp4963596.html
Sent from the Mapserver - User mailing list archive at Nabble.com.