Access Stored Procedure in ADO

[Huynh Quang Cuong]

Need Help to access Stored Procedure in ADO.


I use ADO to connect to ODBC data source (OLE DB Provider for Visual Foxpro).Try to call a stored procedure in this data base but a Visual Basic raise an error.

Please help me to solve this problem as well as help me call a stored procedure in Visual Foxpro database throught ODBC (use ADO)


Thanks in advance.

Cuong.

[George]

there is command object in ADO I think you know. set the property of commandtype to "adCmdStoredProc", and of course, you must have it available in your database.


regards


George

[Huynh Quang Cuong]

Thank George.


I had tried doing it, but it just works on SQL Server DataBase.


H.Q. Cuong

[George]

I am working on MS SQL , don't know others.


I think it should be fine with lots of DB out there. If you want, send me detail and code.


regards


George