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

Help: EP6 sneak preview JDBC -Query iview connection properties

Hi,

These are the steps I have followed for creating JDBC iViews / Query iViews

==========================================================

1. I Created a JDBC system for the MS sqlserver on the portal server. In the properties sheet provide the following values:

Connection TimeOut: 100

Connection String : jdbc:sap:sqlserver://MyComputer:1433;databaseName=MyDatabase

driver : com.sap.portals.jdbc.sqlserver.SQLServerDriver

2. I have created a system alias for the system.

3. In the user management part of the new JDBC System that I created above I have configure it for admin or admin,user

4. Tested the connection: failed

But when I tried the connection (test connection)

The message I get is something similar to

Connection failed: ---

Found default System Alias.

Verify that user mappings and all connection properties are correct.

==========================================================

I dont know what I am missing or doing wrong

Please let me know what I shd change to make this work.

Regards,

Shanker

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 26, 2004 at 02:22 PM

    Hi Shanker,

    > Verify that user mappings [...] are correct

    As far as I can see from your description, you didn't set the user mapping:

    User Administration - User Mapping - Search for the user - Select the system you have defined before - set mapping - save.

    Hope it helps

    Detlev

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.