i am using the odbc data sources ( created from the control panel --> administrative tools --> odbc data sources ) to connect the crystal report to my access database . all things good and the data sources works like a charm , till i discover that generating the report several times quickly can corrupt the odbc data sources and give an error , noting that the crystal report contains dynamic values for filtering ( a prompt window appear for the values parameters when generating the report ) , check the print screen attached that shows u the error , the database is access 2010 and the report placed in a windows server 2008 R2 XEON 16 GB .
elie.karkafy
0
Junior Poster in Training
Recommended Answers
Jump to PostYou could fill a dataset in code and pass it to crystal if you wanted to skip using a odbc.
See this article for programmaticly setting the datasource for crystal.
Jump to PostIf you are dealing with large amounts of data, you will have a hard time "optimizing" this. You may also want to try a DataReader. They will only grab the data, but not store it in local memory.
Jump to PostThe username/password window is popping up when you use a datareader?
All 9 Replies
Begginnerdev
256
Junior Poster
elie.karkafy
0
Junior Poster in Training
Begginnerdev
256
Junior Poster
elie.karkafy
0
Junior Poster in Training
Begginnerdev
256
Junior Poster
elie.karkafy
0
Junior Poster in Training
Begginnerdev
256
Junior Poster
elie.karkafy
0
Junior Poster in Training
Begginnerdev
256
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.