CDatabase Problem with SQL Server
Posted on 2000-03-17
==> When I am trying to save data by transfering value like m_pSet->m_Name = "sdf" and calling m_pSet->Update() It is giving "RECORDSET IS READ ONLY". The database property has been properly set to allow update,modify,delete etc.
In my SQL Server Database I have set Option checked for APPEND,MODIFY AND DELETE. Pl. see the following :
1) In DOC header class I am declaring an object of CDatabase.(CDatabase mdb)
2) In OnNewDocument() of DOC CPP I am opening the database by
Before that I am creating a new CRecordset Class for my table. and in OnNewDocuement() linking this CRecordset pointer with CDatabase object.
3) Then in OnSave() using
It is doing everything but only giving Recordset is READONLY.
What to do?
=> Will ExecuteSQL("select * from ab") will be perfectly working in SQL Server as ACCESS ? I am facing some problem of not executing it. What may be the error?