Toad World® Forums

TIC Automation error using MS Access

I have published an automation to TIC that opens up a MS Access db and copies the contents of a table into an Oracle table. When I manually run it in Toad Data Point Pro it works fine. However, once I published it to TIC I get the following error when the automation test runs:

Any help would be greatly appreciated - thanks!

Is Access or the ODBC drivers for access installed on the TIC server? It looks like it can’t connect to the Access DB.

You could remote desktop to the TIC server and start up TDP and try your connect and automation script there