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

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 11:23 PM

    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.

    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.