on 10-09-2008 3:55 AM
Hi Guys,
Im quite new here in XI version 7.0..Can anyone help me how to solve my problem..
This my connection from MSQL -> XI -> SAP (RFC)
Im using ms sql 2005. Here are the following info :
jdbc driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
Connect :jdbc:sqlserver://172.16.40.20:1433;databaseName=TRAVEL:SelectMethod=cursor
Once i tried to test my config..error occured :
Im using sa login which is the administrator of the server itself..
Error during database connection to the database URL 'jdbc:sqlserver://172.16.40.20:1433;databaseName=TRAVEL:SelectMethod=cursor' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://172.16.40.20:1433;databaseName=TRAVEL:SelectMethod=cursor': com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "TRAVEL:SelectMethod=cursor" requested by the login. The
login failed.'
Please help.
Thanks in advance
aVaDuDz
use this format
jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=pubs
or replace : to ; after the database name.
databaseName=TRAVEL:SelectMethod
Edited by: Anand on Oct 9, 2008 5:29 AM
Edited by: Anand on Oct 9, 2008 5:29 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
First check with drivers whether have installed properly or not in XI/PI, find below link will help u for driver information.
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html
Meanwhile currently ur using security port 1443, check with ur network team weather have activated or not. Sometimes it is also problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check whether you have deployed, the JDBC drivers in the SAP XI server.
Regards,
Nithiyanandam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Ava
use jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor
The drivers which u require for JDBC adapters are
msbase.jar, mssqlserver.jar, msutil.jar
For deploying these jars, go thru this article
driver for SQL is:
com.microsoft.jdbc.sqlserver.SQLServerDriver
connection is:
jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor
Refer SAP Note 831162
Thanks
Gaurav
Edited by: Gaurav Bhargava on Oct 9, 2008 9:00 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.