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.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
