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
