Update DB

  • Thread starter Thread starter Miha Markic [MVP C#]
  • Start date Start date
M

Miha Markic [MVP C#]

Hi,

Make sure that local windows aspnet account (assuming xp or 2000) or
networking services (w2003) has full privilege on folder where mdb file
resides.
 
Hi,

I got a problem updating MDB file thru ASPX.

error : "System.Data.OleDb.OleDbException: Operation must use an updateable
query."

I update it with this way : (when I updated data in datagrid everything is
perfect)
dbconn = New OleDbConnection(ConfigurationSettings.AppSettings("cn"))
Dim sNumber As Int16
dbconn.Open()
Dim MyCommand As New OleDb.OleDbCommand("SELECT * FROM table1 WHERE
ID = 604", dbconn)
Dim MyReader As OleDb.OleDbDataReader = MyCommand.ExecuteReader()
If MyReader.Read Then
sNumber = MyReader("HitCount")
Dim lNumber As Int16 = sNumber + 1
Else
dbconn.Close()
Exit Sub
End If
MyReader.Close()
MyCommand.Dispose()
MyCommand = New OleDb.OleDbCommand("UPDATE Berita SET Hitcount = "
& lNumber , dbconn)
MyCommand.ExecuteNonQuery()
dbconn.Close()
MyCommand.Dispose()

thanks
any help appreciated
 
Hi Mark,

Thx it works
I should set the asp .net user at the physical folder instead at the IIS.

Miha Markic said:
Hi,

Make sure that local windows aspnet account (assuming xp or 2000) or
networking services (w2003) has full privilege on folder where mdb file
resides.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

ruthness said:
Hi,

I got a problem updating MDB file thru ASPX.

error : "System.Data.OleDb.OleDbException: Operation must use an
updateable
query."

I update it with this way : (when I updated data in datagrid everything is
perfect)
dbconn = New OleDbConnection(ConfigurationSettings.AppSettings("cn"))
Dim sNumber As Int16
dbconn.Open()
Dim MyCommand As New OleDb.OleDbCommand("SELECT * FROM table1 WHERE
ID = 604", dbconn)
Dim MyReader As OleDb.OleDbDataReader = MyCommand.ExecuteReader()
If MyReader.Read Then
sNumber = MyReader("HitCount")
Dim lNumber As Int16 = sNumber + 1
Else
dbconn.Close()
Exit Sub
End If
MyReader.Close()
MyCommand.Dispose()
MyCommand = New OleDb.OleDbCommand("UPDATE Berita SET Hitcount = "
& lNumber , dbconn)
MyCommand.ExecuteNonQuery()
dbconn.Close()
MyCommand.Dispose()

thanks
any help appreciated
Click to expand...
Click to expand...
 
Back
Top