<div>
I set it to adOpenDynamic, but still get the same error - 3251<br />

</div>


I set it to adOpenDynamic, but still get the same error - 3251


<div>
<div class="content wysiwyg-content">
I'm trying to add a row to an ADO recordset, which I will later save to the DB.<br />
<br />
The AddNew method raises an error &quot;The operation is not supported by your provider&quot;<br />
<br />
The syntax is<br />
<br />
rsData.AddNew<br />
<br />
What am I doing wrong? &nbsp;The DSN is ODBC to Oracle 7.3.4
</div>
</div>


I'm trying to add a row to an ADO recordset, which I will later save to the DB.

The AddNew method raises an error "The operation is not supported by your provider"

The syntax is

rsData.AddNew

What am I doing wrong?  The DSN is ODBC to Oracle 7.3.4

ADODB.recordset.AddNew

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.