Failed to retrieve data from the database

[Former Member]

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

[jeff_albion · Accepted solution]

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:

• SQL Anywhere JDBC Driver (Type 2) - Mixed native and Java
• jConnect JDBC Driver (Type 4) - Pure Java

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