Page 1 of 1

Dataviewing Error

Posted: Mon Nov 08, 2010 10:22 pm
by Nagasudheerkumar
Hi All,

I have got below error when viewing Data from the ODBC Stage.
Please guide me what needs to be done further.

Fatal Error: Could not connect to datasource?? (-1; eto; eto; [DataDirect][ODBC lib] Data source name not found and no default driver specified)
> :
>

Posted: Mon Nov 08, 2010 10:28 pm
by ray.wurlod
The DSN you used is not defined in the uvodbc.config file being used by the project. Or, perhaps, that DSN is not defined:
  • (a) if you are on UNIX in the $ODBCINI file

    (b) if you are on Windows as a System or File DSN (DataStage does/can not use User DSNs)

Posted: Mon Nov 08, 2010 10:29 pm
by chulett
:!: Please be mindful of the forum you post in. The FAQ Discussion forum was not appropriate for this post, so I moved it here. Please edit your post and add your particulars - version, O/S, etc.

Posted: Mon Nov 08, 2010 11:26 pm
by Nagasudheerkumar
Iam on the windows still it is showing the same error

Posted: Tue Nov 09, 2010 4:14 am
by ray.wurlod
Did you bother to check the things I suggested?

Or are you looking for Harry Potter to come along and magically repair your environment?

Posted: Tue Nov 09, 2010 4:27 am
by Nagasudheerkumar
Hi Ray,

Thanks for suggesting me. I have given the DSN name correctly now and its working fine now.