Hi Craig
As soon as I saw you were adding the ADO for DDL I knew you had the wrong library. Glad you figured it out.
By the way, Can you leave the entire thread intact when you respond? That helps others follow should they come in mid-way. Just add your new response to the top of the email.
Bill
---In ms_access_professionals@yahoogroups.com, <whyteboar@yahoo.com> wrote:
Bill,
I feel somewhat abashed. I triple checked my references and compared against some online sources and saw I was adding the wrong ado references. So the connections are at least recognized. Now to make them do what they want done...
Thanks,
Craig
---In ms_access_professionals@yahoogroups.com, <wrmosca@...> wrote:
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 (5) |
Tidak ada komentar:
Posting Komentar