OData - Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver not found

[HemendraS]

Hi Experts,

We have developed the Native Online/Offline Mobile App for client in SMP3.0 SP05, which is fetching data from SQL Server using JDBC driver. The app was working fine, but day before yesterday client upgraded the SMP3.0 service pack level to SP08. Now this JDBC driver is giving us the below ERROR:

Connection test failed - Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver not found

However JDBC Driver is placed in a proper location i.e. C:\SAP\MobilePlatform3\Server\pickup. SMP Server Log was as follows:

|2015 10 13 17:50:05#+0530#ERROR#com.sap.gateway.core.odata4sap.ODataErrorCallbackImpl##smpAdmin#http-bio-8083-exec-23####b4f44f81-00ed-4851-b858-ee84f569793d####handleError(): failed to serve request for URI https://XYZ:8083/gateway/odata/RESERVEDFORSAPIGW/REPOSITORYSERVICE/PingDestination?DestinationName=%..., message = Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver not found: Transaction ID :ad1d1f64-6b29-4c63-9bd2-62b2a99d26a6 |

After doing further investigation I found below SAP Note - 0002146914, which says that:

SMP Server Log is as follows:

|

2015 10 14 09:45:18#+0530#ERROR#com.sap.gateway.core.odata4sap.ODataErrorCallbackImpl##smpAdmin#http-bio-8083-exec-2####500c4787-9d48-4417-af6e-aafe761f7ea8####handleError(): failed to serve request for URI https://1XYZ:8083/gateway/odata/RESERVEDFORSAPIGW/REPOSITORYSERVICE/PingDestination?DestinationName=..., message = Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver not found: Transaction ID :96105684-6aaf-4e89-9eb0-3dad4e7ea63a |

But I am still facing the same above problem (Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver not found). Please provide your valuable inputs to eradicate the same.

Thanks,

Warm Regards

Hemendra

[HemendraS · Accepted solution]

Hi Experts,

I found below another SAP Note - 2202778 and it looks like this is good help to resolve above. Thanks Marvin Hoffmann for clue

2202778 - SMP 3.0 SP07 to SP08 server upgrade causes SQLServerDriver not found error

Thanks,

Warm Regards

Hemendra