ODBC stage unable to retreive data in parallel jobs

[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

[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.

[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.

[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".