Universe Design Tool Using JDBC connect Sybase Get Error

Source: Internet
Author: User
Tags sybase sybase database

1 Using SAP Universe design tool to connect Sybase database error, error is as follows:

"Cs:java Class not found in Classpath:com.sybase.jdbc4.jdbc.SybDriver"

Or the error is as follows:

"Cs:java Class not found in Classpath:com.sybase.jdbc3.jdbc.SybDriver"

2 My environment is as follows:

Operating system: Win7, installed: SAP businessobjects BI Platform 4

Database is: Sybase SQL Anywhere 16

The JDBC driver used is: Jconn3.jar

Purpose: I use the SAP Universe Designer tool to connect bppm default Sybase database for report design using JDBC (Sybase IQ 15)

3 Solution:

3.1 Find the JDBC driver jar package, you can use my usual, Baidu address is as follows:

Http://pan.baidu.com/s/1c0Aw9OG

3.2 Copy the drive Jar package to the SAP Drive storage path:

The SAP jar package path is as follows: <intallation Dir of Bo>\sap businessobjects Enterprise XI 4.0\dataaccess\con necti onserver\drivers\ Java\<jar file>

3.3 Modify Sybase.sbo File

The Sybase.sbo file path is as follows: <installation dir of bo>\sapbusinessobjects Enterprise XI 4.0\dataaccess\connectionserver\ Jdbc\sybase.sbo

After Sybase IQ 15, add the following (note change the installation path and the last Jar package name):

< ClassPath > < Path > <  directory for BO>\sap businessobjects Enterprise XI 4.0\dataaccess\connectionserver\ Drivers\java\<file></Path>  </ClassPath>

The examples I've added are as follows (for reference):

<DataBaseActive= "Yes"Name= "Sybase IQ">          <ClassPath>                     <Path>D:\Program files\sapbusinessobjects\sap businessobjects Enterprise XI 4.0\dataaccess\connectionserver\drivers\java\ Jconn3.jar</Path>                     </ClassPath>        <Jdbcdriver>          <!--uncomment and edit the following lines to define Java classes required by JDBC driver 
..............................................................................

After saving, the test is available

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

Universe Design Tool Using JDBC connect Sybase Get Error

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.