JDBC Adapter for SQL Server 2003

[Former Member]

We are trying to connect from XI to SQL Server 2003 for the first time. Does anyone know what values to use for these 2 parms in the JDBC receiver channel:

1) JDBC Driver

2) Connection

[Former Member]

Hello Chris,

Open the receiver to specify the Connections with the Database

Database Connection:

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://SQLSRV:1433;DatabaseName=J2EE

Thanks,

Satya Kumar..

[Former Member]

Hi,

Database Connection

JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection jdbc:microsoft:sqlserver://SQLSRV:1433;DatabaseName=J2EE

User Name (Specify your User name)

Password (Specify your Password at two columns)

Thanks,

Rajeswari...

[vikas_agarwal]

Hi,

JDBC Driver :

jdbc:microsoft:sqlserver://<server name>;DatabaseName=Nameof database

Connection:

com.microsoft.jdbc.sqlserver.SQLServerDriver

If Driver is not installed for SQL than use this doc:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Thanks

[Former Member]

Hi

JDBC Driver :

jdbc:microsoft:sqlserver://<server name>[;DatabaseName=SEPG_NEWDB]

Connection:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Refer my answers here in case you are not able to connect:

Thanks

[Former Member]

Hi Chris,

I think these link will help you

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

http://www.erpgenie.com/netweaver/xi/XI%20Service%20Packs%20Described.doc

*PS: reward points if useful*

Regards,

Sumit gupta