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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thank you!! It's works!

With the change in the sybase.sbo file including the ClassPath and Path tag.