Skip to Content

Connection test of JDBC System fails

Hi,

I create a system for my JDBC system according to this procedure:

***************************************

The steps to create the JDBC Query iView are as follows.

Login as System Administrator,

Navigate to System Administration>System Configuration>System Landscape

Create a new system,

Choose JDBC System>Assign name etc>Open Object for Editing

Under property category choose: “Connection” & assign,

Connection Timeout = 60

Connection URL = jdbc:sap:sqlserver://sqlservername:sqlTCPport;DatabaseName=SQLDBName

Driver Class Name = com.sap.portals.jdbc.sqlserver.SQLServerDriver

SAVE

Change the Property Category to: “Distributed Query Engine”

Enter the admin user\password to the oracle database.

SAVE

Change the Property Category to: “User Management”

Choose admin,user

SAVE

Now change the Display category to System Aliases

Enter a system alias for the system.

Go to user management and assign your login details to the system alias you just created.

Go back to the system in the system landscape and right click and choose connection tests

***************************************

When I choose the connection test I receive a error message. This message said to check user management and properties, but its ok. What's happen?

EP6 SP9 in WebAs 640 SR1

SQL Server 2000 SP3

Andre

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 11:40 AM

    Hi Andre,

    are you talking about an oracle db or a sqlserver? (since you mentioned both...)

    Ok, I assume "oracle" was a mistake.

    Here are my connection properties for connecting to my local portal database:

    -Admin User & password(dqe) are filled with the correct credentials

    -connection timeout: 1000

    -connection factory class: JDBCFactory

    -connection URL: jdbc:sap:sqlserver://127.0.0.1:1433

    -Driver Class Name: com.sap.portals.jdbc.sqlserver.SQLServerDriver

    -SystemName: localSQLServer

    -User Mapping Type: admin, user

    -Validate Connection: No

    That's all and it's working.

    Hope that helps, Karsten

    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.