DSXchange

while trying to view data, on ODBC connector stage, we are getting the following error.

"An exception occurred while trying to send the request to the handler.Request timed out"

The job runs fine but view data is not allowd. Any suggestions ?

compile the job and check the test connect then view the data i will work

After compiling when I tried to test connect it gave an error agent not available

Make sure the agent is running. This could be the Node agent (part of Information Server) or it may be a database agent - you will have to determine this, because we can't.

Just found that the view data works fine via ODBC Enterprise stage. Not sure why the connector is giving issues? As for checking the agent, what is the procedure ?

abhilashnair wrote:Just found that the view data works fine via ODBC Enterprise stage. Not sure why the connector is giving issues? As for checking the agent, what is the procedure ?

Any suggestions ?

Use the Enterprise stage.

ODBC is ODBC, the connector should be just as fast as the enterprise stage.

Don't spin your wheels and waste development time. Throw the question to your admin team, but continue with your developping.

The problem may be with the Connector Access Service. The stack traces and log files (such as SystemOut.log) will help to diagnose whether this is the case. Do you have very many connector stages? If you're not comfortable reading these traces and logs, involve your official support provider.