jdbc iview->no respond from backend application->SQL Server

[Former Member]

hi,

i try to make new JDBC Stored Procedure iview, but when i make a preview i get a message that there is "no respond from backend application".

What is the problem, cause its seems that connection works.. i can select what stored procedure shoule be executed on the backend systems...

Thanks for help!

Karol

[Former Member · Accepted solution]

Hi Karol,

Have you created the JDBC system to access the database ?. First you have to create the JDBC system and alias for the backend system. Then you have set the user mapping for the alias in the personalise section of the portal.You can check the connection while creating the system itself.

The problem might be in the rights of the database user. If you have the System Admin(in SQL) rights for accessing the database, then this problem might get solved. I've faced the similar problem.

[Former Member · Accepted solution]

Hi Saravanan,

yes its a question of rights for accessing the database, cause the test for connectors are succesfull.

How did you solve the problem?

Thanks for help!

[Former Member · Accepted solution]

Hi Karol,

I have created an user with System Admin rights for accessing the backend database.I created the system and system alias for the JDBC system in the enterprise portal. Then I did the user mapping for the system alias to map that user. I have created the SP iView based on the corresponding system alias. It all works well for me.

You better do it one by one from the scratch.

Cheers,Saravanan