Error

[campbere]

I have developed a VB6 application that uses Oracle 8 as a database and when a report name is chosen Crstal Reports. The problem I am having is that in Production the report runs fine. In Development however I get an error:

Report Error 20599 Cannot Find Server. IM006: Microsoft ODBC Driver Manager Drivers SqlSet Connect Attr failed o.


I am trying to figure out what is going on. I feel it's strange that I can run this in prouction but not in development. I have ran the select that the report uses in Oracle in the development area and it runs fine.

Another strange thing that I have noticed is that the report actually runs up to about 65,000 rows and with only a few thousand left it stops and displays the error.

Does anyone have a suggestion? Is there something in Crystal Reports that needs to be set up, or adjusted?

 

[kenhamady]

Are you running out of space somewhere?
Can you run a smaller result successfully? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[campbere]

I am not running out of space. I believe it has something to do with the Service Names. I have read some of Crystal Report Cases on this problem and it sort of points to the connection setup and the data sources. Not really sure about this but I did find another way around the problem.

I noticed that in all of my reports the only ones that I had a problem running in the development area were the ones that had no associated CR Query. So I decided to build one for this report and Voila it works.

Of course I have a new issue. When I build the report using the CR Report Designer I am not given the option to sort by product_name. Do you have any idea why I wouldn't be given the opportunity to sort by product_name? I am having to do it by product_code right now, which really isn't desired. The Sort also defines a group for the tree listing down the side of the report. Users prefer it to be names instead of a bunch of numbers.

 

[kenhamady]

What is the data type and maximum length of the field? See the FAQ on Memo/VarChar fields. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[campbere]

Thanks for the information.

When a crystal reports is being created does it create a temporary table? As I investigate your point about space could be right. I had believed that there was plenty of space in the development area but I learned yesterday that was not true. I have ran other reports on two different tables of considerable smaller size and they did work.

So I am assuming that when CR creates the report it generates a temporary table in doing so?

 

[campbere]

Thanks everyone for all of your comments. I have corrected the problem, actually I just rebuilt the report from scratch and it seems to work just fine. Can't explain it, not 100% what happened but all is well now.

Thanks.