One of my cohorts is having a very difficult time getting things going on her new project. We are running DataStage Server Edition, v. 7.5.1.A running on Windoze (soon to be going to AIX Unix). Her source is Informix and she is using the Informix CLI driver utilizing a DSN that is already working correctly in other projects. Her target is SQL Server 2000 using the OLEDB stage on a server that is also aready successfully being used in other projects.
Once we get the Informix CLI source stage set up with it's connection information, a transform stage put in place and the SQL OLEDB target connection created, and then take the step of going into the source stage and pressing 'View Data' (I know that's a specific order, but that order is what got us the best results), then we get an error box with this text:
I tried rebuilding her job in my project, which has never had this problem, and the same thing happened. I'm leaning toward this being an Informix connection issue of some sort, but I have no idea how to go about fixing it.
DataStage Repository Interface
Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project ALIR
I would appreciate any advice anyone has for this situation. Thanks much!