Skip to Content
0
Former Member
Oct 04, 2005 at 03:00 PM

Problem Connecting to SQL Server using JDBC Connector

19 Views

Hi,

I have problem connecting to MS SQL Server using the JDBC Connector. I have 2 main questions, one is on the DQE and the other is on user mapping.

I have a created a JDBC System Landscape using the portal component com.sap.portal.systems.jdbc.

Following are the properties I have set and also I have listed where I am finding propblems.

- User Management

User MApping Type : Admin, User

- Connection Properties

Connection Timeout: 1000

Connection URL: jdbc:microsoft:sqlserver://10.7.1.5:1433;DatabaseName=SAPEP

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

(Here I do not know whihc driver to use. Do I have to use the above one or this one com.microsoft.jdbc.sqlserver.SQLServerDriver. Anyway, both of them Did not work)

- Distributed Query Engine (DQE) (What is this, and what Parameters I need to pass here)

Also, While doing the user mapping, we need to provide the username and password. What username and password is that? Is it the DB user name and Password?

Any help will be well appriciated.

Thanks and regards,

Babu