SBO0001 Error Involving JDBC Connection for MS SQL Server 08

building semantic layer
1

Hello All,

I’m having a heck of a time connecting in Universe Designer (on BO XIR3 SP2) to the MS SQL Server 2008 DB. I’ve updated the jdbc.sbo file to point to the correct “Classpath” and updated the “Extensions” within this file as well to include “Query, Procedures”; however, I still get an error when I try and connect in Designer that is the following: “DBD: No Suitable Driver”. Any ideas on how to resolve this issue? Thank you for your help. :hb:

Pankaj

snbouser :us: (BOB member since 2006-07-05)

2

Any luck?..we are seeing the same error for this connection

kmspsu93 :us: (BOB member since 2006-04-06)

3

Nope no luck, I tried again today and the error is now changed to:

“Java Class not found in classpath : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc\Drivers\sqlsrv”

But, the issue still exists. :wah:

snbouser :us: (BOB member since 2006-07-05)

4

I’ve heard that path names with spaces can sometimes cause problems. Have you tried moving the files to a 8.3 path?

Dr_N_Sung (BOB member since 2010-09-17)

5

Could you advise on how I would go about doing that? Thanks in advance!

snbouser :us: (BOB member since 2006-07-05)

6

i work (i try to work, actually) with MS SQL 2005.
where do i update the jar? u have any idea?
i’ve noticed many steps that u mentioned, i have no clue about them. where did u read about it? what i suppose to do in order to work with my new connection to MS SQL 2005?

thanks
ohad

OhadR (BOB member since 2011-04-04)

7

Here is how we got it to work:

  1. Obtain the self-extracting archive distributed by Microsoft hosted on their servers: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c47053eb-3b64-4794-950d-81e1ec91c1ba

  2. unzip it and the “sqljdbc_1.2” folder is placed in the following directory:
    \BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc
    For example:
    C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc\sqljdbc_1.2

  3. Open up the \BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc\jdbc.sbo file in Notepad.

  4. Locate the following section’s for the SQL Server database you care to use:

    <DataBase Active="Yes" Name="MS SQL Server 2008">
      <Aliases>
        <!-- You can add an alias here if you are using some connections that are defined with an older database engine -->
        <Alias>MS SQL Server 6.5</Alias>
      </Aliases>
      <Class JARFile="dbd_jdbc,dbd_mssql">com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
      <JDBCDriver>
        <!--  Uncomment and edit the following lines
                     to define java classes required by JDBC driver
                &amp;lt;ClassPath&amp;gt;
                    &amp;lt;Path&amp;gt;your jar or class files directory&amp;lt;/Path&amp;gt;
                &amp;lt;/ClassPath&amp;gt;
                 -->
        <!-- Configuration is done for SQL Server 2008 JDBC Driver -->

And make it look like this (where you substitute “<” for “&lt;” and “>” for “&gt;” and insert the path to the new “sqljdbc.jar” file you put on your computer:

    <DataBase Active="Yes" Name="MS SQL Server 2008">
      <Class JARFile="dbd_jdbc,dbd_mssql">com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
      <JDBCDriver>
        <ClassPath>
            <Path>E:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc\sqljdbc_1.2\enu\sqljdbc.jar</Path>
        </ClassPath>
        <!-- Configuration is done for SQL Server 2008 JDBC Driver (2.0)  -->
        <Parameter Name="JDBC Class">com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
        <Parameter Name="URL Format">jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
      </JDBCDriver>
      <Parameter Name="Family">Microsoft</Parameter>
      <Parameter Name="Version">mssqlserver_jdbc.setup</Parameter>
      <Parameter Name="SQL External File">sqlsrv</Parameter>
      <Parameter Name="SQL Parameter File">sqlsrv</Parameter>
      <Parameter Name="Strategies File">sqlsrv</Parameter>
      <Parameter Name="Driver Capabilities">Query,Procedures</Parameter>
      <Parameter Name="Extensions">sqlsrv2008,sqlsrv,jdbc</Parameter>
      <Parameter Name="Array Fetch Size">10</Parameter>
      <Parameter Name="Force Execute">Always</Parameter>
      <Parameter Name="Quote Identifiers">False</Parameter>
    </DataBase>

dajabon (BOB member since 2003-09-09)