Skip to Content
0
Former Member
Jul 10, 2013 at 09:14 PM

JDBC Config for SQL 2008 on Linux - BI 4.0, SP6, Patch 6.2

43 Views

Hello Experts,

I am trying to configure JDBC Drivers for SQL 2008 on a Linux but getting error when testing the connection.

CS: Building ConnectString/ParamString failed : DBDriver failed to load : java.lang.ClassNotFoundException: com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver

Below is my sqlsrv.sbo file content

<DataBase Active="Yes" Name="MS SQL Server 2008">

<JDBCDriver>

<Class JARFile="dbd_jdbc,dbd_mssql">com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>

<JDBCDriver>

<ClassPath>

<Path>***Install path***\sqljdbc_4.0\enu\sqljdbc4.jar</Path>

</ClassPath>

<Parameter19" data-scayt_word="JDBC">JDBC

Class">com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>

<Parameter>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$

</Parameter>

</JDBCDriver>

<Parameter>sqlsrv2008,sqlsrv,jdbc</Parameter>

<Parameter>Always</Parameter>

</DataBase>

</DataBases>

<!--Configuration is done for SQL Server 2008 JDBC Driver (2.0) -->

Doesn't work for the server and client configuration. Please provide me any notes and tell me what is actually wrong here..Thanks,