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
how i can make my odbc connection more faster when generating data throug it
Begginnerdev
256
Junior Poster
If 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.
elie.karkafy
0
Junior Poster in Training
ok but i am using the dynamic values parameters in crytsal report for filtering , in the pop up windows the error is appearing, check the print screen above ,
Begginnerdev
256
Junior Poster
The username/password window is popping up when you use a datareader?
elie.karkafy
0
Junior Poster in Training
yes after several successive generates of the report through vb ..
Begginnerdev
256
Junior Poster
This is begginning to sound a lot like a crystal problem and not a vb.net problem.
Have you contacted their support team?
Beware! Ask about a price (if any) or you may be hit with a "small" phenomenal fee.
elie.karkafy
0
Junior Poster in Training
yeh its a crystal report problem , but why the report generate normally up to 8 times and syddenly give this error its seems that the odbc data sources that are linked to the database can't handle a lot of data load
Begginnerdev
256
Junior Poster
It could be a limitation in their software.
Possibly a datasource not being release or plain ole memory leak.
Anything is possible when using 3rd party software.
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.