<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=796465003-26062005><FONT face=Arial>Hello
folks,</FONT></SPAN></DIV>
<DIV><SPAN class=796465003-26062005><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=796465003-26062005> <FONT face=Arial>I have a
connection to a SQL Server via DSN and an ovf file to pull some point data as a
layer and was wondering if it is at all possible to use parameterized requests.
A wiki on the mapserver webpage describes how to build an ovf but if the
SrcLayer is a stored procedure, can one use a parameter for the stored procedure
in the map file? The only option I have seen is FILTER, but that obviously
doesn't submit a needed parameter for a stored procedure. I guess my question is
of an OGR connection can pass a parameter to a stored procedure rather than just
filtering an entire recordset.</FONT></SPAN></DIV>
<DIV><SPAN class=796465003-26062005><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=796465003-26062005> <FONT face=Arial>Another
related question is if I can use a DSN-less connection to a SQL Server directly
from a map file.</FONT></SPAN></DIV>
<DIV><SPAN class=796465003-26062005><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=796465003-26062005><FONT face=Arial>Thanks for any
ideas,</FONT></SPAN></DIV>
<DIV><SPAN class=796465003-26062005><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=796465003-26062005><FONT face=Arial>David
Shorthouse</FONT></SPAN></DIV></BODY></HTML>