
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