Hi !
I have a big problem in reading data from a Oracle 8.i table using Ado
I have something like that (VB6):
Dim cnn as new adodb.connection
Dim rst as new adodb.recordset
cnn.open "Provider=MSDAORA.1;User ID=sys;Data Source=PROVA_192.168.3.22;Persist Security Info=False"
rst.open "Select ColOfStringType,ColOfDateType from OracleTable",cnn
if rst.eof then exit sub
msgbox rst.fields(0).value
msgbox rst.fields(1).value << - this line raise the error :"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"
Why I cannot READ data from a date type field?
Any sugestion ?
I have a big problem in reading data from a Oracle 8.i table using Ado
I have something like that (VB6):
Dim cnn as new adodb.connection
Dim rst as new adodb.recordset
cnn.open "Provider=MSDAORA.1;User ID=sys;Data Source=PROVA_192.168.3.22;Persist Security Info=False"
rst.open "Select ColOfStringType,ColOfDateType from OracleTable",cnn
if rst.eof then exit sub
msgbox rst.fields(0).value
msgbox rst.fields(1).value << - this line raise the error :"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"
Why I cannot READ data from a date type field?
Any sugestion ?