Getting Database query error...

Tech-Archive recommends: Fix windows errors by optimizing your registry

I tested my code on my local computer and it worked fine. When I
uploaded it to my webserver at Godaddy.com, I get the following
error...

Exception Details: System.Data.OleDb.OleDbException: Operation must use
an updateable query.


The line of code with the error is:
objCmd.ExecuteNonQuery


The rest of my code is as follows:

dim Conn as new OleDbConnection("Provider=" & _
"Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=mypath.mdb")

dim objCmd as OleDbCommand = new OleDbCommand _
("NewUserInput", Conn)
dim objReader as OleDbDataReader
objCmd.CommandType = CommandType.StoredProcedure



dim objParam as OleDbParameter

objParam = objCmd.Parameters.Add("@FirstName", _
OleDbType.char)
objParam.Direction = ParameterDirection.Input
objParam.Value = tbFN.Text


objParam = objCmd.Parameters.Add("@LastName", _
OleDbType.char)
objParam.Direction = ParameterDirection.Input
objParam.Value = tbLN.Text

objParam = objCmd.Parameters.Add("@Email", _
OleDbType.char)
objParam.Direction = ParameterDirection.Input
objParam.Value = tbEmail.Text

objParam = objCmd.Parameters.Add("@Zip", _
OleDbType.char)
objParam.Direction = ParameterDirection.Input
objParam.Value = tbZip.Text


objCmd.Connection.open()
objCmd.ExecuteNonQuery


objCmd.Connection.close()


Any help would be appreciated

Thanks,
RABMissouri

.

Relevant Pages

  • Weird message in application log
    ... I am using IIS6/w2k3 as my webserver and I see these events in my ... The local computer may not have the necessary registry ... message DLL files to display messages from a remote computer. ... Support for details. ...
    (microsoft.public.inetserver.iis)
  • Re: php free hosts
    ... Install MySQL and a webserver on your local computer. ... Regards, ... Matthias ...
    (comp.lang.php)