CRecordset problem... When trying to Open,it says ODBC driver doesn't support Dynasets

Do you know what is the problem?

How can I read and write to fields in a Recordset without the need of deriving a CRecordset class?

Thanks in advance
Skel
skelAsked:
Who is Participating?
 
inprasCommented:
Hi
CRecordset rs;
rs.Open(CRecordset::dynaset, "SELECT * FROM MyTab", none);
and access the fields

to update
CDatabase db;
db.Open(...);
db.ExecuteSQL("UPDATE TABLE tab1 SET...");

Hope this helps
inpras
0
 
yclCommented:
Yes,use SQL clause is a effective way.
0
 
skelAuthor Commented:
But when I use rs.Open(CRecordset::dynaset, "SELECT * FROM MyTab", none); I get the error that ODBC Driver doesn't support dynasets....

Finally I'm trying using DAO... I have more experience on that

Skel
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.