<div>
The recordset could be readonly, even if you have checked all options.<br />
post your SQL which you use to open the recordset
</div>


The recordset could be readonly, even if you have checked all options.
post your SQL which you use to open the recordset

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

</div>
</div>


==> 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 
mdb.Open(NULL,FALSE,FALSE, strconnect,.....).
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 
m_Pset->Edit()
m_Pset->m_Name="sfdsdfdsf"
m_Pset->Update()

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? 


CDatabase Problem with SQL Server

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.