on 10-18-2007 1:25 PM
Hi All,
I am working on SQL->Sender JDBC->XI----->Reciever RFC -
> SAP scenario.
I have completed the configuration of the scenario.
The sql server is mySQL 2000.
Hence, in the sender JDBC adapter, i have given the following details.
JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection: jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
my connection: jdbc:microsoft:sqlserver://172.20.20.76:1143[;DatabaseName=SEPG_NEWDB]
In Runtime Workbench->Component Monitoring>Adapter Engine--->Communication Channel Monitoring..
I am facing error as follows.....
Error during database connection to the database URL 'jdbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'
What might be the reason behind this error....??????
Kindly help me.....
Regards
Pavan
what's is the driver which you have deployed for this database?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what i meant was have you deployed the proper jar file(driver file) in the .sda file in using SDM......your driver parameter is fine just check this below
download the jdbc driver from url http://download.softagency.net/MySQL/Downloads/Connector-J/
(mysql-connector-java-3.1.14-bin.jar if you are using mysql 4.0)
the your parameter in Dapter
DBC driver: com.microsoft.jdbc.sqlserver.sqlserverdriver
connection: jdbc:microsoft:sqlserver://ip:port;databasename
also check this
tther option is download JDBC Driver from Microsoft Website
and deploy the JDBC driver using SDM.
JDBC Driver Deployment Guide...
how to configure drivers:
also http://www.oracle.com/technology/software/tech/windows/odbc/index.html
Hi All,
I am working on mysql 2000 ->JDBC>XI> RFC--->SAP scenario.
The deployed Driver (found in Control Panel-->Administrative Tools) is as follows...
SQL Server
Version: 2000.85.1117.00
In XI-->JDBC sender, i have entered the Driver as com.microsoft.jdbc.sqlserver.sqlserverDriver
The Connection is as follows...
dbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]
I am able to ping the SQL server through command Prompt.
But in XI>Runtime Workbench->Communcication Monitoring, I am getting an error for sender JDBC adapter as folllows.....
Error during database connection to the database URL 'jdbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]' using the JDBC driver 'com.microsoft.jdbc.sqlserver.sqlserverDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.'
Now what to do in order to get the connection to SQL server through XI.....????
Please help me, if i am wrong in definging connection path for sender JDBC adapter......
Regards
Pavan
you parameter shouls looks like
JDBC-Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection: jdbc:microsoft:sqlserver://10.94.22.99:1433;DatabaseName=COS
your parameter are
com.microsoft.jdbc.sqlserver.sqlserverDriver
dbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]
Confirm wether have you deloped these driver in the SDA file?sqljdbc.jar (for UNIX)
msbase.jar
mssqlserver.jar
msutil.jar
ojdbc14.jar
cross check your connection parameters with tha above one
hi ,
i am getting this error when trying to connect to SQL driver(2000),
'jdbc:microsoft:sqlserver://192.168.100.146:1433;DatabaseName=haier_office' failed: com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://192.168.100.146:1433;DatabaseName=haier_office': ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
can any one tell me why is it happening like this?
As per ur first post, the connection string should be <b>d</b>atabaseName instead of
<b>D</b>atabaseName.
Regards,
Shabari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.