Failed to connect Sybase to BI via UD connect , JDBC connect

[Former Member]

Hi,

I try to connect Sybase and BI wih using JDBC connection based on SAP Guides :

How to Transfer Data from SYBASE to BI Using UD Connect.pdf

How to Configure UD Connect on the J2EE Server for JDBC Access to External Databases.pdf

Then I try to test JDBC connection with Visual Composer by using URL http://<server>:<port>/TestJDBC_Web/TestJDBCPage.jsp

and I try to test "SDK_JDBC" and click Check Connections, it is gives me an error

500 Internal Server Error

SAP J2EE Engine/7.00

Application error occurred during request processing.

Details:

java.lang.NoClassDefFoundError: com.sap.ip.bi.sdk.dac.connector.odbo.impl.Connection (initialization failure)

Exception id: 00145E74A198006200000AA0000B91A6000482E7D9CDD471

The configuration that I've set :

1. JCo RFC Connector

program ID :BIdev_PORTAL_BID

gateway Host : bidev

gateway service : sapgw00

application server host : bidev.smr.com

user : j2ee_admin

2. in RFC destination in BW (SM59) :

program ID :BIdev_PORTAL_BID

gateway Host : bidev

gateway service : sapgw00

3.Driver :

Driver name : SYBASE

add 4 files : jconn3.jar, jTDS3.jar,jconn3d.jar, jTDS3d.jar

4.Connector container :

BI_JDBC_CONNECTOR : reference : library:SYBASE

5.Properties tab :

Driver name : com.sybase.jdbc2.jdbc.SybDatasource

URL:jdbc:sybase:Tds:190.165.0.1:2368?map

username : username in database map

password : password

Then I run smoke test URL http://190.165.0.1:2368/TestJDBC_Web/TestJDBCPage.jsp

I haven't configure setting environment JDBC_HOME and CLASSPATH on J2EE visual composer, I don't know where to set, could somebody help me with these issues..

Thanks,

Jane

[Former Member]

This looks old but it looks like here is your problem...

Your driver name does not correspond to the version of the driver file you load. You load the jconn3.jar (notice the 3). Then you use com.sybase.jdbc2.jdbc.SybDatasource (notice the 2).

This is why you are getting the class not found error, you need to fix the driver name to match the driver name inside the jconn3.jar.

[Former Member]

Hello Jane,

We are trying to connect BI 7.0 (AIX 5.3,Oralce10g) to MS-SQL Server 2005 using UD connect.

We are receving the similar error message "Application error occurred during request processing.

Details: java.lang.NoClassDefFoundError: com/sap/ip/bi/sdk/dac/connector/odbo/impl/Connection

Exception id: [00096B6BFB820056000003F10008F062000488165C099206]"

How did you resolve the issue?

Did you set the parameters CLASSPATH and JDBC_HOME?

if so, what was the values you provided for the two parameters ?

I look forward for your reply.

Regards,

Wahab.