[mapserver-users] mssql with mapserver on red hat

[mmmoatmeal]

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.