Cannot reset ODBC error

[jancheta]

Hi. I have several apps written in A2K that extracts information via ODBC which are triggered at specific time intervals (via Scheduled Tasks). Problem is that if the extract fails due to an ODBC error, I tried to trigger the timer event of the form for it to wait and run again say in 5 minutes but it won't work. Then I tried creating a form that calls the extract form within the database, but it seems that A2K remembers the first ODBC error. Then I tried to refresh the links, but got the same result.

The only other thing that I can think of is to create say a A2K Launcher app that will call the other extracts (access databases). The Launcher app will have a table where the other extracts are linked to and will continuously monitor the table for any errors. If an error occurs, after say a few minutes, it'll call the specific extract that errored out. (Hopefully this will work)

Any ideas are greatly appreciated. Thanks in advance!

Jason

 

[xlbo]

You may get a better response if you ask this in the ODBC forum:
forum706

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[jancheta]

Geoff,

Thanks for your suggestion. I'll re-post in that forum.

Jason

 

[xlbo]

No probs - your question is perfectly relevant here and you never know - someone may answer it but I would've thought you'll have more joy in the other forum. Hope someone there can help

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244