There are a few similar posts but none of the solutions seem to have worked.
Version: SQL Server 2005,
ODBC Driver: Centura SQLBase 3.5 32-bit Driver -NT & Win95
I've got an SSIS which executes successfully in BIDS and MSSMS. However when I schedule the SSIS it fails with the error message:
DOMAIN\DOMAIN_ACCOUNT. ...on 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 15:38:12 Error: 2010-12-02 15:38:13.46 Code: 0xC0047062
Source: Customer Copy DataReader Source  Description: System.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could not be loaded due to system error 126 (Centura SQLBase 3.6 32-bit Driver -NT & Win95).
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvide
View Complete Post