>Hi All,
>
>I thought I'd try a simple Active Server page for my FoxPro back end. I've got a burgeoning application that shares data between 4 departments, EACH with their own business rules for that same data. An Intranet sounded perfect.
>
>I have a data-mart that's essentially a crosstab query. I've built a multi-tiered, parameterized view that replaces the procedures that build the table that is cross-tabbed. I made all this a stored procedure in my DBC. Oh, it works great!
>
>Now, I come to ODBC, which won't allow the passing of parameters. ADO seem to use ODBC, so I can't get around the limitations. I even tried using an Insert - SQL statement that puts my parameters into a logging table, but the ODBC driver errors out. Yes, I'm using 5.0!
>
>So my questions are ...
>
>1. Can one execute stored procedures via a trigger in FoxPro over ODBC?
>2. Can one return values from an OLE server that are not written to a form, grid, etc?
>3. Is it possible to create a public class that is based on a cursor .. ie returned from
> SELECT * FROM x INTO CURSOR y
>4. Should I just use the evil Oracle or SQL Server and forget this exercise?
>
>Thanks in advance for any (non-flaming) input!
>
>Sincerely,
>
>Rod Wagoner
>Tucson Electric Power

I am not going to be much help on most of your questions, but are you using the most current ODBC drivers from MS? I had much trouble with erlier and non-MS versions of ODBC drivers. The latest drivers resolved the problems I had. These drivers are free to download from the MS web site --

http://www.microsoft.com/products/prodref/264_ov.htm