"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/09/2005 12:24:11 PM:

> Has anyone had experience with this yet? My attempts so far render 
> "ODBC--call failed". My connection is good and I can use select 
> statements successfully, but no luck with calling an SP yet. I 
> really want to call an SP with parameters, but I'm trying a simple 
> one first. Also, anyone know of a forum dedicated to using Access as
> a front-end to MySql?
> 
> Thanks in advance...again.
> 

Your options depend on if you are using OLEDB, ADO, or DAO to communicate 
with the ODBC driver. Refer to the appropriate library documentation to 
figure out how to get a recordset from a command.

If you are using ADO, I would look closely at these objects.methods: 

Connection.Execute

Command.Execute (along with the Parameter object)

Recordset.Open

But you say you are in MS Access, so I guess you are using DAO to control 
the ODBC connection? I am too rusty with DAO to suggest anything there.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


Reply via email to