select stops at 8200 records

[ist1809]

Hi Guys,

we have a problem with an ODBC-Connection via DataDirect to a Progress 91E-DB. The select statement stops at (round about) 8200 records. 2 weeks ago, the DB was on V91C and the driver was Open Link, there were no problems with reading more then 10.000 records. If we connect to the DB via SQL-Explorer, there ist no problem, too.

What's to do to get all records of a selection? Are there some settings we do not know?

Thank's
Ingo

 

[schaapie]

Post the query, so we can have a look at it.
When you perform grouping on the server there might be a problem with temp-space, which is crashing the query?
Does the query run with a simpeler select statement? That is, no group-by's, calculated fields, sums, counts etc.

 

[ist1809]

Hi,

we changed the driver. Now the Application works with OpenLink and the problems are done.

Thank you

By
Ingo