Thanks Shawn. I'm actually trying using Access's Pass-Through Query
technology
which utilizes ODBC. I'm not sure if it's ADO or DAO. I'll guess ADO
since
that's the default for this version of Access (2002). I haven't tried
connecting in code yet, but that's coming soon. I've had a lot of
experience
with Access and MS SQL Server, but I'm a MySql newbie. Do you have a
favorite
desktop front-end to MySql other than Access?

I really appreciate your help and suggestions. 

>>> [EMAIL PROTECTED] 08/09/05 10:48AM >>>


"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