on 10-01-2014 10:18 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.