VB 4 and DAO 3.5/ODBCDirect 
Author Message
 VB 4 and DAO 3.5/ODBCDirect

I have tried to use DAO 3.5 with ODBCDirect to access an Oracle7 database
using Visual Basic. (and Intersolv ODBC 3.0) It seems to be working except
for:

1) There is a new datatype vbDecimal (VarType: 14). Oracle NUMBER datatype
is mapped to this type. The new type works with implicit conversions but
not explicit:
        s = "Value: " & rs(0)     ' Works
        s = CStr(rs(0))         ' Don't work

2) I can't get the DAO 3.5 recordsets to work with the Data control:
        Data1.Recordset = qd.OpenRecordset      ' Don't work

Have anyone noticed anything else? Or is it save to use DAO 3.5 with VB4?

Mats Larsson
Agero, Sweden



Sat, 21 Aug 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Q: DAO 3.5 w/ODBCDirect call Oracle SP w/Output Params

2. DAO 3.5 ODBCDirect and stored procs help

3. DAO 3.5 ODBCDirect and stored procs help

4. Moving from DAO 3.5 to DAO 3.6

5. DAO 3.5 & DAO 3.51 work differently

6. Convert DAO 3.5 to DAO 3.6 Jet Engine 4.0

7. DAO 3.5 vs DAO 3.51

8. DAO 3.5 object library vs. DAO 3.51

9. DAO 3.6 vs DAO 3.5 (VB6.0 sp3)

10. VB4 is DAO 3.5 safe, or DAO 3.0 better

11. VB4 is DAO 3.5 safe, or DAO 3.0 better

12. DAO 3.0 vs DAo 3.5

 

 
Powered by phpBB® Forum Software