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 (1) |
Tidak ada komentar:
Posting Komentar