As mentioned in http://mapserver.org/input/vector/mssql.html#option-1-connect-through-ogr adding ";Tables=<table>(<geom_column>)" might help. You can try to add OPTION MSSQLSPATIAL_USE_GEOMETRY_COLUMNS NO at MAP level to avoid reading the "geometry_columns"-Table. I guess the SRID will be reported as -1 then and you need to define a PROJECTION block at the LAYER. You can use the DATA statement to define the SQL for your layer.
HTH > -----Ursprüngliche Nachricht----- > Von: Vogt, Robert (RCIS) [mailto:[email protected]] > Gesendet: Mittwoch, 2. November 2016 16:49 > An: Eichner, Andreas - SID; [email protected] > Betreff: RE: msOGRFileOpen > > Yes, thank you! I figured that out(so many different configuration :)) > > I'm curious OGR doesn't seem to be able to find my SRID and it also looks > like it pulls ALL fields...this seems inefficient > > Is there a way to pass custom SQL to OGR and only include columns that are > needed and the SRID? > > -Bob > > > > -----Original Message----- > From: Eichner, Andreas - SID [mailto:[email protected]] > Sent: Tuesday, November 01, 2016 12:30 PM > To: Vogt, Robert (RCIS); [email protected] > Subject: AW: msOGRFileOpen > > From http://www.gdal.org/drv_mssqlspatial.html and the linked page about > ODBC driver connection string (http://msdn.microsoft.com/en- > us/library/ms130822.aspx) it seems you need to use "UID" and "PWD" instead > of "username" and "password" > > HTH > > > -----Ursprüngliche Nachricht----- > > Von: mapserver-users [mailto:[email protected]] > > Im Auftrag von Vogt, Robert (RCIS) > > Gesendet: Dienstag, 1. November 2016 14:36 > > An: [email protected] > > Betreff: [mapserver-users] msOGRFileOpen > > > > Good morning, > > > > I have successfully tested my connection string with "ogrinfo", now > > however when I try to use that connection string in my MapFile I > > receive this error... > > > > msDrawMap(): Image handling error. Failed to draw layer named 'myLayer'. > > msOGRFileOpen(): OGR error. Open failed for OGR connection in layer > > `myLayer'. Unable to initialize connection to the server for > > MSSQL:Database=mydatabase;Server=myServer;user=myUser;password=XXXXXXX > > XXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX SQL Server Driver][SQL > > Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' > > > > Any help is greatly appreciated!! > > > > _______________________________________________ > > mapserver-users mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
