By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,523 Members | 1,938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,523 IT Pros & Developers. It's quick & easy.

Can't connect Access Databse In My DomainServer

P: 1
hai all,

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/nsc/tracking/signup.asp, line 17

the code is:
<%
set con=server.CreateObject("ADODB.connection")
set rs=server.CreateObject("ADODB.recordset")
con.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("shipmentLogin.mdb")
'con.open "DSN=LoginDSN"
response.write server.mappath("shipmentLogin.mdb")
16------------sql="insert into tblLogin values('" & Request.Form("UserID") & "', '" & Request.Form("Client") & "','" & Request.Form ("Name") & "','" & Request.Form("Password")& "')"
17---------rs.Open sql,con,1,3

18-------Response.Write "<B> <font color=blue size=4>Successfully Created</B></font> "

'rs.Close
set rs=nothing
con.Close
set con=nothing
%>


this code worked in my local system(http;//localhost/). that fine..i can uplode this into my website ....whenever i entered data that error shows..

i gave all permissions to that database file...

pls help me........
Nov 30 '06 #1
Share this Question
Share on Google+
1 Reply


sashi
Expert 100+
P: 1,754
hai all,

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/nsc/tracking/signup.asp, line 17

the code is:
<%
set con=server.CreateObject("ADODB.connection")
set rs=server.CreateObject("ADODB.recordset")
con.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("shipmentLogin.mdb")
'con.open "DSN=LoginDSN"
response.write server.mappath("shipmentLogin.mdb")
16------------sql="insert into tblLogin values('" & Request.Form("UserID") & "', '" & Request.Form("Client") & "','" & Request.Form ("Name") & "','" & Request.Form("Password")& "')"
17---------rs.Open sql,con,1,3

18-------Response.Write "<B> <font color=blue size=4>Successfully Created</B></font> "

'rs.Close
set rs=nothing
con.Close
set con=nothing
%>


this code worked in my local system(http;//localhost/). that fine..i can uplode this into my website ....whenever i entered data that error shows..

i gave all permissions to that database file...

pls help me........
Hi there,

Are you sure r/w permission is given to the folder as well to the contents of the folder? Please check out these details. Good luck & Take care.
Nov 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.