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
Problem with View Data for a user
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
This problem is fixed in version 8.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am