I have just started using MonetDB and created several tables. When
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 on his computer. Could anyone please tell me if there is any way to resolve this problem?
Thanks and regards
PS. The VB code I use to connect to the database via and write a value into the table:
Sub dbf_OpenDB()
Dim rs_MONETDB As Recordset
Dim db_GLOB as Database
Set db_GLOB = DBEngine.Workspaces(0).OpenDatabase("", False, False, "DSN=MonetDB;")
Set rs_MONETDB = db_GLOB.OpenRecordset("SELECT * FROM tablename;")
While Not rs_MONETDB.EOF
i = i + 1
rs_MONETDB.Edit 'once code gets here it tells me that database or object is read only
rs_MONETDB("columnname") = value
rs_MONETDB.Update
rs_MONETDB.MoveNext
Wend
End Sub