DSXchange

Hi,
We have a new user who is getting the following error when doing a view data on a ODBC stage....

GE_Data_Call..odbcgeCall: DSD.BSIConnect connecting to $PROJDEF, call to SQLConnect failed.
SQLSTATE=IM002,DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The job runs fine and I as well as other developers can do a "view data" with no problem in the job.

Am I missing some permissions or setup for this user?

Thanks - - John

just a note...the user was given full permissions to the sqllib folder on the DS server and also added to the DB2ADMNS group on the server as well.

In version 7 View Data will not substitute for $PROJDEF - you need to replace $PROJDEF with an actual value (the DSN in this case).

This problem is fixed in version 8.

Thanks Ray...I asked around and some of the consultants had the same issue but never reported it. I guess it depends on the individual desktop configuration, since it works fine for me and a few other developers.

As always Thank You for your answer!!!