Page 1 of 1

ODBC stage unable to retreive data in parallel jobs

Posted: Mon Jul 14, 2008 1:55 am
by Pavani_Vithala
Hi all,

While retreiving data through ODBC stage in IIS 8.0, it is throwing an error "An exception occured while trying to receive the response from the handler: An exception was received from the handler: Failed to initialize the data producer. the select statment may be invalid"...

Requesting you to please guide me how to resolve the problem.

Regards,
Pavani

Re: ODBC stage unable to retreive data in parallel jobs

Posted: Mon Jul 14, 2008 2:37 am
by mahadev.v
the select statment may be invalid"
Is the select query the same in both the server job and the parallel job? Paste the query here.

Posted: Mon Jul 14, 2008 3:13 am
by patil.bnk
Did this problem occur earlier?also u can check the permission of the user of db.I also had the problem earlier this was due to software.

Posted: Mon Jul 14, 2008 3:21 am
by ray.wurlod
U is one of our members. U is unlikely to want to do what you suggest, since it was not U who posted the question. The second person personal pronoun in English is spelled "you".