Skip to Content
author's profile photo Former Member
Former Member

JDBC Connectivity with BI Platform 4.0 and Sybase IQ 15.4 on Linux

Hi All,

I am trying to make a connection on the Universe Design Tool and the Information Design Tool using JDBC but I get the following error:

"CS: Java Class not found in classpath : com.sybase.jdbc3.jdbc.SybDriver"

It turns out that Sybase IQ 15.4 is using jConnect version 7.0 which makes use of the following class: "com.sybase.jdbc4.jdbc.SybDriver".

I have added the following variables: JAVA_HOME, JDBC_HOME, and CLASSPATH and modified the sybase.sbo to point to jconn4.jar (instead of jconn3.jar) file as per the following link: http://www.sybase.com/detail?id=1093263 but to no avail.

Can anyone help me out please?

Thanks in advance and best regards,

Ron

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2013 at 02:22 PM

    Dear Ron,

    Could you please do the following :

    1. locate the jar file specific for the Sybase 15 database.

    2. Copy The jar file to the location : <Intallation Dir of BO>\SAP BusinessObjects Enterprise XI 4.0\dataAccess\con necti onServer\drivers\java\<jar file>.

    3. Add the path in sybase.sbo file in the following directory <Installation directory for BO>\SAPBusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\Sybase.sbo.

    Under Sybase IQ 15, Add the following:

    <ClassPath>

    <Path>

    <Installation directory for BO>\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\driv ers\java\<jar file>

    </Path>

    </ClassPath>

    Test the issue then.

    Please refer also to this KBA "1629250 - BI 4.0 Java Class Not Found In Classpath Or No Suitable Driver Found For JDBC" :

    http://service.sap.com/sap/support/notes/1629250

    I hope this helps.

    Best and Kind Regards,

    Ameni

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.