Odbc

[weiwei]

We have a crystal report for student report. It runs OK before, but recently after I run it, it takes much longer time, if I run for a student, it takes 8 minutes, and generate the report, but if I run a grade level, it will keep running and gives error:
Querry engine error: 'HY000: [DataDirect-Technologies][ODBC Progress driver][Progress]Server not reachable or possible RPC error'

Any suggestions would be appreciated.

 

[Casper]

There are many knowledgebase entries on this issue. Did you go through them already? http://progress.atgnow.com/esprogress/Group.jsp

Search for: Server not reachable or possible RPC error

Regards,

Casper.

 

[weiwei]

I've already searched the knowledge center of progress, and tried all possible ways, but no luck at all

 

[BONO]

Have you check the compatibility between progress db and odbc driver and the crystal reports version. with CR9 for example you need to add registry keys for outer join else you have an error. For CR11 you have to be in 9.1E at less.

do you launch the report from crystal report or from an application who use crystal interactivity ?

 

[weiwei]

We use crystal reports 10. odbc driver is Merant 3.60 32 bit progress SQL 92 v9.1 D

 

[BONO]

For crystal 10 you have P84577 who explain registry key needed for outer join syntax error. Else for your error like Capser told you you have many entry on progress knowledge base.