<div>Julia</div><div><br></div>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. <div><br></div><div>Regarding to the issue of
<span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">" the procedure entry point msSmallMalloc could not be located in the</span><br style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">dynamic library libmap.dll"</span> this looks like an older version of libmap.dll is used actually, which may not be compatible with the mssql plugin.</div>
<div><br></div><div>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.</div>
<div><br></div><div><br></div><div>Best regards,</div><div><br></div><div>Tamas</div><div><br></div><div><br><br><div class="gmail_quote">2012/2/24 juliap <span dir="ltr"><<a href="mailto:japr94@hotmail.com">japr94@hotmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thanks for the suggestion,<br>
<br>
I was able to create a spatial index for the database using ogrinfo. I even<br>
exported information from sql server to a shapefile using the ogr2ogr<br>
utility.<br>
<br>
However; I want to be able to get data directly from a query in the mapfile,<br>
instead of having to create a shapefile. Right now this doesn't work when I<br>
use CONNECTIONTYPE OGR, and the same string that I used to connect for the<br>
previous examples.<br>
<br>
Also, I tried to use the mssql2008 plugin, and I used dependency walker and<br>
it seems that most of the required libraries cannot be found ...<br>
<br>
Do you have any idea of what the problem could be?<br>
<font color="#888888"><br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.n6.nabble.com/mssql2008-plugin-not-working-failed-to-load-dynamic-library-tp4492672p4504015.html" target="_blank">http://osgeo-org.1560.n6.nabble.com/mssql2008-plugin-not-working-failed-to-load-dynamic-library-tp4492672p4504015.html</a><br>
</font><div class="im">Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
</div><div><div></div><div class="h5">_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br></div>