>I created a Stored Procedure in my VFP database. The SP return
>the age when the parameter date of birth is passed. I tried to
>call the SP in a Select-SQL (using ODBC) like this:
>
>Select distinct fcGetAge("02/11/1966") from AnyTableOfDatabase
>... the query returns 35. Everything works fine... yesterday.
>
>But today, I tried the same query and I got the following message:
>[Microsoft][ODBC Visual FoxPro Driver]Feature is not available
>
>What is the problem with ODBC today?
It shouldn't work either day. SP calls are not supported using the ODBC driver. The only SPs that are run when you use ODBC are ones called in triggers.
FWIW, the OLE-DB provider that comes with VFP 7 can execute SPs.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao