Getting Database query error...

[RAB]

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.Ole Db.OleDbExcepti on: Operation must use
an updateable query.
The line of code with the error is:
objCmd.ExecuteN onQuery
The rest of my code is as follows:

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

dim objCmd as OleDbCommand = new OleDbCommand _
("NewUserInput" , Conn)
dim objReader as OleDbDataReader
objCmd.CommandT ype = CommandType.Sto redProcedure

dim objParam as OleDbParameter

objParam = objCmd.Paramete rs.Add("@FirstN ame", _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbFN.Text
objParam = objCmd.Paramete rs.Add("@LastNa me", _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbLN.Text

objParam = objCmd.Paramete rs.Add("@Email" , _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbEmail.Text

objParam = objCmd.Paramete rs.Add("@Zip", _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbZip.Text
objCmd.Connecti on.open()
objCmd.ExecuteN onQuery
objCmd.Connecti on.close()
Any help would be appreciated

Thanks,
RABMissouri

[Teemu Keiski]

Hi,

the error indicates that there's not enough/correct permissions set for
accessing the mdb file. E.g the user the application runs under should have
at least read/write permissions to the folder where mdb file resides. As is
evident, it is a thing to discuss with your hoster.

Before contact8ng your host, make sure that you provide the full and correct
path to the mdb file within the connection string (e.g if you have mdb on
your web app folders, which is not desirable solution, since anyone could
download the file, you could get full physical path to the mdb file by
using Server.MapPath)

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
http://blogs.aspadvice.com/joteke

"RAB" <ra*********@ya hoo.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

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.Ole Db.OleDbExcepti on: Operation must use
an updateable query.
The line of code with the error is:
objCmd.ExecuteN onQuery
The rest of my code is as follows:

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

dim objCmd as OleDbCommand = new OleDbCommand _
("NewUserInput" , Conn)
dim objReader as OleDbDataReader
objCmd.CommandT ype = CommandType.Sto redProcedure

dim objParam as OleDbParameter

objParam = objCmd.Paramete rs.Add("@FirstN ame", _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbFN.Text
objParam = objCmd.Paramete rs.Add("@LastNa me", _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbLN.Text

objParam = objCmd.Paramete rs.Add("@Email" , _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbEmail.Text

objParam = objCmd.Paramete rs.Add("@Zip", _
OleDbType.char)
objParam.Direct ion = ParameterDirect ion.Input
objParam.Value = tbZip.Text
objCmd.Connecti on.open()
objCmd.ExecuteN onQuery
objCmd.Connecti on.close()
Any help would be appreciated

Thanks,
RABMissouri

[RAB]

I called my web host and they said the folder where I have my Access
database has "full priviledges". Is there something else that might be
the problem?

Thanks,
RABMissouri