Skip to Content
author's profile photo Former Member
Former Member

EP 6.0 SP 2: JDBC iView display 2 empty lines

Hello,

i create 4 JDBC iViews with the wizard. I connect to a MS-SQL Server, run a stored procedure an display the result. At first there are 3 empty lines. Then the table with the SQL result will display.

Has anybody an idea, what's happend?

Thanks

Stephan

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2004 at 07:31 AM

    Stephan,

    I have cretaed a JDBC iview from the wizard. I have specified the database system also to the iview. When i select query option or stored procedure option, i am not able to get the list of tables in the next screen? Can u tell me what steps i am missing?

    Thanks,

    Mital.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2004 at 07:27 PM

    Has your user enough rights in the database?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Shankar,

      Thanks for the help.

      I have followed the steps.

      Can you confirm the following things which i am trying.

      1.While creating sql system in portal,for distributed query engine i specified

      user name =sa

      password=*****

      is this right?

      2. For personalization option what user mapping i need to give.

      I dont have idea on specifying usrename password for this?

      Is that should be windows logon username password?

      Can you please help me on this?

      Thanks,

      Mital.