Help Needed : Setting JDBC Datasource in Crystal XI using Sybase 12.5??

[Former Member]

All,

We are migrating our systems to the Crystal XI from Crystal 9 Reporting Servers. I need some technical assistance on the Java API ( use of the Datasources) .

Problem: Currently in Crystal 9 we are using OLEDB datasources to connect to various Sybase 12.5 databases (which is been set programmatically at runtime). After I changed the Java code for getting the report object from the Crystal XI server instead of 9. I stared facing the dbLogon failed exceptions.. But surprisingly it does work randomly on only one datasource for a given session (AppServer Restart).

Need Help on Topics:

1. Is there any different way of configuring/usage the OLEDB datasources for CrXI? or any Java API changes while setting the datasource when using OLEDB?

2. Configuration required for using Simple JDBC connection (Sybase) instead of OLEDB? Can I get detailed help on this.

I will prefer using JDBC for CrXI using the Sybase 12.5, but there are very less documentation for how to configure and set databases at runtime.

Many Thanks in Adv.

Regards - Sudhir Deshmukh | Solutions Lead

[Former Member · Accepted solution]

Hi Sudhir,

For Building up a connection for OLEDB we need :

In order for Crystal Reports to connect to a database through OLE DB, there are some requirements that must be met:

u2022 The database client software must be installed on the client machine.

u2022 The client machine must be able to connect to the server from its client software

u2022 The client softwareu2019s working directory (example. c:\orant\bin) must be in the Windows search path

u2022 The OLE DB provider must be installed on the local machine.

We have the connection for crystal reports through OLEDB :

The process by which Crystal Reports access data from an OLE DB data source consists of these five layers:

Crystal Reports Layer

OLE DB Translation Layer

OLE DB Layer

DBMS Translation (OLE DB provider) Layer

Database Layer

The data translation is similar to the ODBC connection model. Crystal Reports uses CRDB_ADO.DLL to communicate to the OLE DB provider, which communicates to the database. Crystal Reports can connect to any database as long as that database has an OLE DB provider.

When creating a new report in Crystal Reports, OLE DB data sources are found in the Create New Connection folder with the OLE DB (ADO) connection.

Regards,

Naveen.