on 11-28-2007 7:43 AM
Hi All,
I have configured a sender JDBC Adapter with the following parameters.
JDBC Drivers: com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection: jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB
But in Runtime, I am getting error as follows...
Error during database connection to the database URL 'jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;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://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.'
It has been confirmed that JDBC Drivers are properly deployed.
Any suggestions to resolve this issue?
Regards
Pavan
Hi
Check whether you are using the same format
JDBC Driver :
jdbc:microsoft:sqlserver://<server name>[;DatabaseName=SEPG_NEWDB]
Connection:
com.microsoft.jdbc.sqlserver.SQLServerDriver
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Check this format ...
Microsoft SQL Server
jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
weblogic.jdbc.mssqlserver4.Driver
Oracle Thin
jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
oracle.jdbc.driver.OracleDriver
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavan,
I think Port is missing and also it should be look like this. (microsoft not required for SQL SERVER 2000).
Make sure msbase.jar, msutil.jar, mssqlserver.jar are the driver files and deployment.
Connection: jdbc:sqlserver://MIS-SERVER\MIS_DEV_SVR<b>:PORT</b>;DatabaseName=SEPG_NEWDB
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
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.