Hi,

Thanks for your interest in MonetDB/SQL.

I think you are making use of "Updatable ResultSets" or something alike. Updatable Cursors (cursors in general) are not implemented in MonetDB.

Can you use UPDATE or INSERT statements instead?

On 11-10-2006 11:33:49 +0100, Djordje Djokovic wrote:

<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><div>Dear MonetDB users,</div><DIV>I have just started using MonetDB and created several tables. When <DIV><FONT face=Arial size=2><SPAN class=922345809-11102006>I try to write data to the database via the ODBC driver (using iSQL-Viewer, Visual basic or MS Access) I always get the same problem which tells me that either the database is read-only or that the ODBC driver is not supporting it. reading is not a problem. A friend of mine has the same problem&nbsp;on his computer.&nbsp;Could anyone please tell me if there is any way to resolve this problem?</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=922345809-11102006>Thanks and regards</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=922345809-11102006></SPAN></FONT>&nbsp;</DIV><DIV><FONT face=Arial size=2><SPAN class=922345809-11102006>PS. The VB code I use to </SPAN></FONT><FONT face=Arial size=2><SPAN class=922345809-11102006><FONT color=#800000>connect to the database via and write a value into the table:<BR><BR>Sub dbf_OpenDB()<BR>&nbsp;&nbsp;&nbsp; Dim rs_MONETDB As Recordset<BR>&nbsp;&nbsp;&nbsp; Dim db_GLOB as&nbsp;Database<BR>&nbsp;&nbsp;&nbsp; Set db_GLOB = DBEngine.Workspaces(0).OpenDatabase("", False, False, "DSN=MonetDB;")<BR>&nbsp;&nbsp;&nbsp; Set rs_MONETDB = db_GLOB.OpenRecordset("SELECT * FROM tablename;")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; While Not rs_MONETDB.EOF<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i = i + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs_MONETDB.Edit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'once&nbsp;code&nbsp;gets here it tells me that database or object is read only<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs_MONETDB("columnname") =&nbsp;value&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs_MONETDB.Update<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs_MONETDB.MoveNext<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wend<BR>End Sub</FONT><BR></SPAN></FONT></DIV></DIV></FONT>

Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users