i am trying to create a mapserver layer from a spatial table in mssql on another server. the mapserver is running on a red hat linux server. i cannot get it to connect. i have setup unixodbc and freetds. i have a dsn setup, which i can successfully connect to and query using isql.
in my mapfile i have connection for the layer like this ... ... CONNECTIONTYPE OGR CONNECTION "MSSQL:dsn=[mydsn];driver=FreeTDS;uid=[user];pwd=[pass];database=[mydb]" DATA "SELECT ... etc'" ... ... the error i get is this msDrawMap(): Image handling error. Failed to draw layer named test'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `test'. Unable to initialize connection to the server for MSSQL:dsn=[mydsn];driver=FreeTDS;uid=[user];pwd=[pass];database=[mydb], [unixODBC][Driver Manager]Data source name not found, and no default driver specified i have tried several variations for the connection string and with never any success. does anyone else use a setup this way? or possibly provide some assistance or some insight on how i can get this to work? or is there a better way? i have found a couple of posts searching but nothing that is working for me. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/mssql-with-mapserver-on-red-hat-tp4992557.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
