![connect database to crystal report 10 connect database to crystal report 10](https://s3.amazonaws.com/files.thereportviewer.com/images/database-expert.png)
CONNECT DATABASE TO CRYSTAL REPORT 10 CODE
WCHAR * 0x02B86E1C "foo_bar_bar\ 0"Ī) Crystal with SP6 sends the database-name with escaped underscore, likeĬrw32 974-c70ĞXIT SQLTablesW with return code -1 (SQL_ERROR) We assume, the reason is the syntax of the database-name.Ī) Crystal without SP6 sends the database-name like Pat Müller After many hours of analyzing the trace-logs, we found the following two facts:Ī) Crystal reports 10 without SP6 (10.0.0.533) works with MySQL-Driver 3.51.12 and 3.51.23ī) Crystal reports 10 with SP6 (10.) works with 3.51.12 BUT NOT with 3.51.23!
CONNECT DATABASE TO CRYSTAL REPORT 10 UPDATE
Mysql> update foo_bar_foo.t set c3='this is not a test' One points to database foo_bar_bar, and the other to foo_bar_fooĢ) Created a new blank report in Crystal.Ĥ) Created two new ODBC(RDO) connections, one for each DSN created in (1)ĥ) select table t from the first of the two current connections and move it to the selected paneĦ) select View/Field Explorer if not already openħ) Drag the three fields from the table to the report.ĩ) press F5 or the Refresh button to get the data from the server -> OKġ0) mysql> update foo_bar_bar.t set c3='this is not a test' ġ1) select Database/Verify Database -> OKġ2) press F5 or the Refresh button to get the data from the server -> OK the change is visibleġ3) select Database/Set Datasource Locationġ5) expand the second connection listed (the one that is not currently being used)ġ6) highlight table 't' in this datasource, and click 'update' -> OK the field has already been changed back to the initial valueġ7) for completeness, select Database/Verify Database -> OKġ8) press F5 or the Refresh button to get the data from the server -> OK Mysql> insert into foo_bar_foo.t values (1, 'a','this is a test') ġ) Created two DSN's, using 3.51.23 driver. Mysql> create table foo_bar_foo.t (C1 INT, C2 CHAR, C3 Text) Mysql> insert into foo_bar_bar.t values (1, 'a','this is a test') Mysql> create table foo_bar_bar.t (C1 INT, C2 CHAR, C3 Text) If they don't then please include your table create in your next update so we can see whether some individual field in your table may be root of your problem. Have you tried cloning your problem table to a database that does NOT have underscores to verify that those characters are definately source of the problem?Ĭould you also tell me whether the steps below stimulate the problem in your environment. If these steps are correct we'll need to do some further troubleshooting to isolate the problem. Could you please take a look at the following scenario I've created and tell me how closely this resembles what you are doing? Following these exact steps I had no problems using the English version of Crystal Reports XI Developer. Sorry you're still having difficulties with this. Using of an older version like 3.51.12 isn't possible anymore, because of the error with the Long-Blobs who returns no values (which is fixed in newer version). If the databasename has a underscore, the error occurs randomly on some of the used tables.
![connect database to crystal report 10 connect database to crystal report 10](https://beansoftware.com/ASP.NET-Tutorials/Images/Crystal-Reports-Provider.jpg)
If the databasename doesn't have a underscore all works fine. (We use the german version of crystal, I'm not sure, if this is the exact english translation) We are not absolutely sure, if databasenames without underscore are never affected from this problem.ġ.) Open a existing (working) Crystal-reportģ.) Error "Could'n find table XY_Z in database. Even in the newest 3.51.19 (and 3.51.20) this problem occurs.
![connect database to crystal report 10 connect database to crystal report 10](https://www.sourcecodester.com/sites/default/files/images/admin/crystal_reports_using_local_database.jpg)
![connect database to crystal report 10 connect database to crystal report 10](https://i.stack.imgur.com/eCVEq.png)
If you have to refresh/verify a report definition in Crystal Reports 10 (Build, SP6) you get "randomly" errors for databases with underscore in its name.īefore using newer versions then "ODBC 3.51.12" everything worked fine.