Problem with View Data for a user

JPalatianos · Post by **JPalatianos** » Thu Dec 10, 2009 11:27 am

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

JPalatianos · Post by **JPalatianos** » Thu Dec 10, 2009 12:14 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 10, 2009 4:04 pm

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.

JPalatianos · Post by **JPalatianos** » Fri Dec 11, 2009 7:45 am

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!!!