January 16, 2002 at 9:34 am
I have a DTS package with an Informix ODBC connection. The package executes fine. When I try to schedule it as a job it gives me an error trying to load the ODBC driver.
When I test ran the package I executed it from the server. I also executed the package via command line. All were successful.
This is the error I get when it is scheduled as a job:
Error: -2147467259 (80004005); Provider Error: 160 (A0) Error string: Specified driver could not be loaded due to system error 126 (Informix-CLI 2.5 (32 bit)). Error source: Microsoft OLE DB Provi... Process Exit Code 1. The step failed.
Any help would be appreciated!
-JG
January 16, 2002 at 9:47 am
I had several problems with informix connections, assuming you can connect OK, it is then probably an MDAC issue, try installing MDAC 2.6RTM <later versions may cause U problems> (for details how to uninstall any higher version Visit microsoft.com/data..also use component checker to see if U have multiple mdac versions installed) ..Reconmend testing via DTS command line for completion (any DTS job should return back to a command prompt when finished..
My last issue was it did not work when scheduled or via command line, but worked fine if run interactively) .. finally tracked issue to MDAC, uninstalled all version's installed 2.6RTM.. then worked ok
(it took 3 v.hard stressed days though)
Hope this helps
January 23, 2002 at 6:40 am
RESOLUTION:
I upgraded the MDAC to 2.5 SP2. Althought this did not correct the problem I started to get a different error. I upgraded the Informix ODBC driver and that did the trick.
-JG
-JG
January 23, 2002 at 11:59 am
Thanks for the followup. What version worked BTW?
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 23, 2002 at 12:34 pm
Went from Informix ODBC CLI 2.1 to Informix 3.31
-JG
January 23, 2002 at 12:45 pm
I currently use version 3.33.00.10749 informix ODBC Driver..works well..
When the right MDAC version is (installed).
Some MDAC versions do have issues with some of the informix drivers (i found out the hard way)..I use MDAC 2.6 RTM with the above driver
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply