I have a SQL Job that calls a DTS package which in turn connects to a
Progress dB and downloads. This has worked perfectly for months.
However it's stopped working for no apparent reason.

If I run the DTS package manually it connects perfectly and then I can
run the SQL Job from Step 2 and it completes. The message that the job
reports when failing to connect is: -

Specified driver could not be loaded due to system error 126
(DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E).

Error source: Microsoft OLE DB Provider for ODBC Drivers

However, when I check the ODBC Driver that is set up fine too and the
'Test Connection' succeeds.

Any pointers to sort this out would be greatfully recieved.

Thanks

Craig Willis

Hello craiggiarc (AT) gmail (DOT) com,

This sounds like the user that is running the job cannot see the driver AND/OR
the DSn to the db is not setup for the user.

Something working manually and as a job are two different beasts. The peson
doing the execution can change and also the location of execution changes.

have a read of this

http://support.microsoft.com/?kbid=269074


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks for your thoughts on this, I went through the MS support
suggestions but unfortunatly it didn't resolve the situation.

Craig