Skip to Content
avatar image
Former Member

Failed to retrieve data from the database

Hi

I have been having issues with Crystal Reports (XI)

1 I am using a jdbc connection and Connector/J 5.1.33 (java).

This worked for a couple of days then failed to retrieve data from the database then to missing driver so fixed that by using an earlier version of jar file 5.1.15

2.Now database I am using is showing up but sometimes i can pull one table with no issues or I cant pull any tables and errors in the attachment below

How do I fix this once and for all

(other info only one of the computers is having this issue

Error 1

failed to retrieve data from the database.

Details: SQL Exception: [ SQL State:] 08s01 {error message:]

Communications link failure

the last packet successfully received from the server was 385,875 milliseconds ago. the last packet successfully to the server was 2 milliseconds ago

Error 2

failed to retrieve data from the database.

Details: SQL Exception: [sql state:] 08003 [error message:] no operations allowed after the connection closed.

Error 3

failed to retrieve data from the database.

details:exception: [error message:] Java heap space

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 01, 2014 at 09:32 PM

    Hi Ricardo,

    Connector/J is used with MySQL databases - this forum is for the SQL Anywhere database. If you're really using a SQL Anywhere database, you should use one of the included JDBC libraries that comes with SQL Anywhere for compatibility:

    Which version of SQL Anywhere are you using with Crystal Reports? If you're really using MySQL, you may want to try re-posting your question to the Crystal Reports community.

    Regards,

    Jeff Albion

    SAP Active Global Support

    Add comment
    10|10000 characters needed characters exceeded