DAO3.6, Ora-DB via ODBCDirect, RecordCount -1, no Moves, no use of VARCHAR2(2000)-Fields

DAO3.6, Ora-DB via ODBCDirect, RecordCount -1, no Moves, no use of VARCHAR2(2000)-Fields

Post by Katharin » Sat, 17 Jun 2000 04:00:00



Hi!

I have a (no, several, but this one is the most current...) problem in
accessing an Oracle-DB (8.1.5, Oracle-ODBC-Driver with the same version) via
DAO3.6, ODBCDirect.

To get a recordset, type dynamic, I had to change the workspace's
DefaultCursorDriver to dbUseServerCursor. Since then I only get recordsets
(snapshots,too) with RecordCount=-1 (help say this is only with to an
mdb-file attached tabled), I can't do Moves machen, then I get

*** ERROR:
Descr.:Unzul?ssige Operation.
Error-Number: 3219
Source: DAO.Recordset
***

and I can't access large text fields (VARCHAR2(2000)), then I get

*** ERROR:
Descr.:S1C00: [Oracle][ODBC]SQLGetData called and SQLExtendedFetch rowset
size is not one <100>.
Error-Number: 0
Source: ODBC.Field
Descr.:ODBC-Aufruf fehlgeschlagen.
Error-Number: 3146
Source: DAO.Field
***

(I'm waiting for oracle support to answer me that, too)

Does anyone have an idea?
I would be glad with any tip.

Katharina

 
 
 

DAO3.6, Ora-DB via ODBCDirect, RecordCount -1, no Moves, no use of VARCHAR2(2000)-Fields

Post by Katharin » Sat, 17 Jun 2000 04:00:00


Update to ODBC Driver 8.1.5.6.0 solved it all

 
 
 

1. DAO3.6, Ora-DB via ODBCDirect, RecordCount -1, no Moves, no use of VARCHAR2(2000)-Fields

Hi!

I have a (no, several, but this one is the most current...) problem in
accessing an Oracle-DB (8.1.5, Oracle-ODBC-Driver with the same version) via
DAO3.6, ODBCDirect.

To get a recordset, type dynamic, I had to change the workspace's
DefaultCursorDriver to dbUseServerCursor. Since then I only get recordsets
(snapshots,too) with RecordCount=-1 (help say this is only with to an
mdb-file attached tabled), I can't do Moves machen, then I get

*** ERROR:
Descr.:Unzul?ssige Operation.
Error-Number: 3219
Source: DAO.Recordset
***

and I can't access large text fields (VARCHAR2(2000)), then I get

*** ERROR:
Descr.:S1C00: [Oracle][ODBC]SQLGetData called and SQLExtendedFetch rowset
size is not one <100>.
Error-Number: 0
Source: ODBC.Field
Descr.:ODBC-Aufruf fehlgeschlagen.
Error-Number: 3146
Source: DAO.Field
***

(I'm waiting for oracle support to answer me that, too)

Does anyone have an idea?
I would be glad with any tip.

Katharina

2. SQL7, Connection and sqloledb

3. Installation problem using dao3.6 and Access 2000

4. Data Problems

5. Using dao3.5 on an Access 2000 system

6. Interleaved 2 of 5

7. VB6 - NoMatch Property of DAO3.6 recordset object MISSING after DAO3.51->DAO3.6

8. Techical Knowledge

9. pb ODBCDirect, DAO3.5 AND vb5 on Access97

10. Error3251+DAO3.5+ODBCDirect+XL97

11. VC5, DAO3.5, MFC and OdbcDirect

12. Problem with RecordCount in DAO3.0.