Error in configuring JDBC Adapter

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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