Error establishing connection to JDBC

[former_member192892]

Hi guys,

I'm doing a JDBC to file scenario. I'm using MS SQL as my database. I'm getting an error as class not found 'com.microsoft.jdbc.sqlserver.SQLServerDriver'

I wanted to know have i provided the JDBC driver correctly for MS SQL,

Also I've given the connection URL as

jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=Employee

Is this a correct way??

If not please help me on this guys and tell me the correct connection establishment parameters...

Thanks

Varun

[Shabarish_Nair · Accepted solution]

http://www.microsoft.com/downloads/details.aspx?FamilyID=6D483869-816A-44CB-9787-A866235EFC7C&displa...

Find the right driver there and deploy the JDBC driver using SDM.

JDBC Driver Deployment Guide -

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

[former_member192892]

Thanks alot guys...It worked....

Regards

Varun

[Former Member]

Varun,

2 chances.

1. You have not deployed the jdbc drivers correctly.

2. The JDBC drivers are not deployed at all.

Ensure, the JDBC drivers you use correspond to the correct DB version.

Regards,

Jai Shankar