ODBC connection to MS SQL 2000 help needed

[Mark Wieder]

Thursday, March 30, 2006, 9:34:50 AM, Jan wrote:

> There's nothiong worng with your SELECT query ; the

<g>

> problem is in the ODBC database driver not always
> returning the correct record count. I've seen this
> with Access and Progress databases as well.

See BZ #3291 for details about revNumberOfRecords(). Issuing a "SELECT
COUNT(1)" query on the recordset data seems to work properly.

> Unfortunately, some databases only support read-only
> forward-only cursors -- so you should traverse the
> record set and fetch all the data you want in one go.

Actually, the database cursors for *all* ODBC databases are
implemented as forward-only, which is a really stupid design decision.
The official excuse for this is that "the docs document that certain
ops don't work with certain databases"...

Please add votes to BZ #1528 to get this fixed. It's been idle for
some two years now...

-- 
-Mark Wieder
 mwieder at ahsoftware.net