[mapserver-users] msOGRFileOpen

[Vogt, Robert (RCIS)]

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:Andreas.Eichner at sid.sachsen.de] 
Sent: Tuesday, November 01, 2016 12:30 PM
To: Vogt, Robert (RCIS); mapserver-users at lists.osgeo.org
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:mapserver-users-bounces at lists.osgeo.org] 
> Im Auftrag von Vogt, Robert (RCIS)
> Gesendet: Dienstag, 1. November 2016 14:36
> An: mapserver-users at lists.osgeo.org
> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users