Craig - Do you have the ADO library referenced?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
I'm so close but still no cigar. I find numerous examples on how to execute an Informix Routine (Stored Procedure) using ADO, but for reasons I have not yet figured out, the 'user defined function' fails at the >>>
Function ExecuteProcedureAdox()
'Purpose: Execute a parameter query using ADOX.
Dim cat As New ADOX.Catalog
>>>Dim cmd As ADODB.Command
Dim lngCount As Long
I have a 64bit install of Windows 7, IBM Connect (IBM Informix ODBC Driver) 4.10.00 and I've tried using both Access 2010 Pass-through query and simple module. The module simple fails (see above) but the pass-through (Call "sp_agent_state_data"('2013-09-01 00:00:00','2013-09-03 00:00:00')) runs several minutes before returning an empty table.
Have any of you tacked this before and can tell me what I'm missing? I'd really rather not re-create the routines if it can be avoided. Thanks!
Craig
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar