>I am trying to call a test procedure in VFP6 from VB6 using ADO and the VFP ODBC driver. I specified the command type either as stored procedure or text (SQL statement) and tried numerous variations of the command like "ProcName", "CALL ProcName", "{ CALL ProcName }" etc.
>I get one of the following VFP ODBC-driver errors:
> 1. Access violation or syntax error.
> 2. Syntax error.
>The procedure itselt does not do anything. It merely returns a numeric value.
>
>Any help will be appreciated.
>
>Mike
Mike
As far as I know VFP ODBC driver accept only SQL Statement.
I don't use it but I think you can found a OLEDB provider ( using DBF ) from Sequiter.
Marcel
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only