Error in JDBC channel

[Former Member]

Hi All

Am getting the following error in my JDBC sender/receiver channel.

Error during database connection to the database URL 'jdbc:sqlserver://<host>;<databaseName> using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver':'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

While installing drivers we followed SAP Note 1138877.

Any kind of help appreciated

Regards

Soumen Das

[Former Member]

Hi,

SAPClassNotFound is an error related to that particular driver classes not found ...

HTH

Rajesh

[Former Member]

The connection problem could be because of wrong Port number, user, password. Also make sure firewall settings are open to establish the connection.

[MichalKrawczyk]

Hi,

>>The connection problem could be because of wrong Port number, user, password.

but it's :SAPClassNotFoundException

can this happen from any other thing except missing driver classes ?

Regards,

Michal KRawczyk

[Former Member]

> but it's :SAPClassNotFoundException

>

> can this happen from any other thing except missing driver classes ?

You are right Michal. It could be because of missing driver classes.

[Former Member]

but it's :SAPClassNotFoundException

can this happen from any other thing except missing driver classes ?

Precisely!!!

Anyways, issue solved...thanks fr d inputs guys

[Former Member]

Hi Somen,

Will you please tell me how did solve the problem.

what procedure u followed to solve this?

please tell me the format of

Driver paramter

connection string for SQL Server 2008

Best Regards

[MichalKrawczyk]

Hi,

this means that the jdbc driver was not installed correctly

try doing the note once more and deploy the driver once more

Regards,

Michal Krawczyk