Unanswered: ORA-01403 Error using OLEDB with VB app & Oracle 9.2
I've got a VB6 app using OLEDB to communicate with an Oracle 9.2 DB. When I get the recordset (ADO) back from a query & try to step through the values in the collection I get either a null response or the ORA-01403 error msg (No data found) rather than the data columns I'm trying to retrieve. Issuing the select through SQL+ works showing the data that's available that I know is there and I want to use in my app.
Anyone hit the same problem? I seem to remember it happening to me once a long time ago but don't recall how I fixed it (if I did or if I ended up doing something else to make it work).