[mapserver-users] Re: mssql2008 plugin not working / failed to load dynamic library

[Tamas Szekeres]

Julia

According to your first letter (and by making sure you use mssql instead of
mysql) I think you should modify the mapfile including the correct
connection parameters.

Regarding to the issue of  " the procedure entry point msSmallMalloc could
not be located in the
dynamic library libmap.dll" this looks like an older version of libmap.dll
is used actually, which may not be compatible with the mssql plugin.

BTW: With the current approach, connecting to mssql via OGR provides better
performance than using the mssql plugin. This is because the plugin forces
to convert the geometries to WKB at server side with is less efficient than
retrieving the data in the native SqlGeometry/Geography serialization
format.


Best regards,

Tamas



2012/2/24 juliap <japr94 at hotmail.com>

> Thanks for the suggestion,
>
> I was able to create a spatial index for the database using ogrinfo. I even
> exported information from sql server to a shapefile using the ogr2ogr
> utility.
>
> However; I want to be able to get data directly from a query in the
> mapfile,
> instead of having to create a shapefile. Right now this doesn't work when I
> use CONNECTIONTYPE OGR, and the same string that I used to connect for the
> previous examples.
>
> Also, I tried to use the mssql2008 plugin, and I used dependency walker and
> it seems that most of the required libraries cannot be found ...
>
> Do you have any idea of what the problem could be?
>
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/mssql2008-plugin-not-working-failed-to-load-dynamic-library-tp4492672p4504015.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120224/dc6b9841/attachment.html