...

View Full Version : Error Type: what's should i do..?



sumidave
08-16-2007, 09:17 AM
Hello, i need some help here.. i dont understand this error message? can u help me about it...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xfd4 Thread 0xfd0 DBC 0x1122024 Jet'.
/FINAL_2/reservation.asp, line 67

Daemonspyre
08-16-2007, 02:06 PM
Have you tried a Google Search?

"General error Unable to open registry key 'Temporary (volatile) Jet DSN for process"

First Entry:
http://www.attention-to-details.com/newslog/38n-temporary-volatile-jet-dsn-for-process.asp

sumidave
08-17-2007, 09:27 AM
thanks for the link... Now i've facing this problem ....

Error Type:
Provider (0x80004005)
Unspecified error
/FINAL_2/reservation.asp, line 86

Daemonspyre
08-17-2007, 03:00 PM
Can you post lines 80 - 90?

sumidave
08-21-2007, 11:17 AM
now i am facing this problem...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/FINAL_2/reservation.asp, line 270


i right click my databases.. and check the box whether it's tick or not on the read only... it's showed untick... what should i do..?

Roelf
08-21-2007, 11:33 AM
what should i do..?

Provide some more detail. What code is causing that error???

Daemonspyre
08-21-2007, 02:01 PM
It may be set as READ-ONLY in the folder it's under.

Make sure your IUSR account has WRITE and MODIFY access to the database.

sumidave
08-22-2007, 10:26 AM
Provide some more detail. What code is causing that error???

<!-- #include file="adovbs.asp" -->
<!-- #include file="connection.asp" -->

<html>

<head>
<title> Online Bus, Van and Ship Ticket Reservation </title>
<script type="text/javascript" src="select.js"></script>
<script type="text/javascript">
window.onload = function() {
dynamicSelect("trip", "time");
dynamicSelect("time", "price");
}
</script>
<script language="JavaScript" src="gen_validatorv2.js" type="text/javascript"></script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
</script>
</head>
<style>
A {text-decoration : none}
</style>
<body bgcolor="#FFFF66" background="images/bg.gif">
<div id="Layer1" style="position:absolute; left:481px; top:11px; width:0px; height:7px; z-index:1"></div>
<table width="100%" border="0" cellpadding="2" cellspacing="2" align="center">
<div id="Layer2" style="position:absolute; left:0px; top:1px; width:800px; height:126px; z-index:2;"><img src="images/logo1.gif" width="801" height="146"></div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<div id="Layer3" style="position:absolute; left:-1px; top:147px; width:802px; height:22px; z-index:3"><img src="images/bar1.gif" width="802" height="28"></div>
<p align="center">&nbsp;</p>
<p align="center"><a href="index.asp"><img src="images/313.png" width="75" height="70" border="0"></a></p>
<form method="post" action="">
<tr>
<td width="100%" align="center" colspan="2">
<p>&nbsp;</p>
<p><font face="verdana, arial, helvetica, sans-serif" size="4">Welcome To
Online Bus, Van and Ship Ticket Reservation<br>
</font> <font face="verdana, arial, helvetica, sans-serif" size="2"> Timenet
Internet Café<br>
394, Chulia Street 10200 Georgetown, Penang, Malaysia<br>
Tel: 04-2645093, Fax: 04-2637301<br>
<br>
</font> <font face="verdana, arial, helvetica, sans-serif" size="2" color="#FF0000">
Please select your destination, time and date. </font> </p></td>
</tr>
<tr>
<td height="30" width="40%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
From Penang to :
</font>
</td>
<td height="30" width="60%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<select id="trip" name="trip" style="font-face:verdana">
<option value="select">Select Destination</option>
<% set conn = createobject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")
conn.open condrv
sqldest = "SELECT DISTINCT TDest FROM Trip"
rs.open sqldest, conn, 1, 3

if not rs.EOF then
do while not rs.EOF %>
<option value="<%response.write(rs.fields("TDest").Value)%>">
<%=rs.fields("TDest").value %>
</option>
<% rs.movenext
loop
end if
conn.close
set conn = nothing
set rs = nothing %>
</select>
<select id="time" name="time" style="font-face:verdana">
<option class="select" value="select">Select Time</option>
<% set conn = createobject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")
conn.open condrv
sqltime = "SELECT TDest, TTime FROM Trip"
rs.open sqltime, conn, 1, 3

if not rs.EOF then
do while not rs.EOF %>
<option value="<%response.write(rs.fields("TDest").value & rs.fields("TTime").value)%>" selected class="<%response.write(rs.fields("TDest").value)%>">
<%=rs.fields("TTime").value %> </option>
<% rs.movenext
loop
end if
conn.close
set conn = nothing
set rs = nothing %>
</select>
</font>
</td>
</tr>
<tr>
<td height="30" width="40%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Trip Date :
</font>
</td>
<td height="30" width="60%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<select name="fday">
<option value="select">Select Day</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="fmonth">
<option value="select">Select Month</option>
<option value="01">January</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</Option>
</select>
<select name="fyear">
<option value="select">Select Year</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
</select>
</font>
</td>
</tr>
<tr>
<td height="30" width="40%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Price :
</font>
</td>
<td height="30" width="60%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<select id="price" name="TID" style="font-face:verdana">
<% set conn = createobject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")

conn.open condrv

sqlprice = "SELECT TDest, TTime, TPrice, TID FROM Trip"
rs.open sqlprice, conn, 1, 3

if not rs.EOF then
do while not rs.EOF %>
<option class="<%response.write(rs.fields("TDest").value & rs.fields("TTime").value)%>" value="<%response.write(rs.fields("TID").value)%>">
<%response.write("RM " & rs.fields("TPrice").value & ".00")%>
</option>
<% rs.movenext
loop
end if
conn.close
set conn = nothing
set rs = nothing %>
</select>
</font>
</td>
</tr>
<tr>
<td height="50" width="100%" align="center" colspan="2">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<input type="submit" value="Check Availability">
</font>
</td>
</tr>
</form>
<tr>
<td height="50" width="100%" align="center" colspan="2">
<%
dim fday, fmonth, fyear, fdate, trip, time, TID, CID
dim maxpax, seat, totalpax, aseat, RTID, tripdate, BStatus
dim curday, curmonth, curyear, curdate, rdate, totalprice
dim chkcurdate, chkrevdate, valdate
valdate = false
aseat = 0

trip = request.form("trip")
time = request.form("time")
fday = request.form("fday")
fmonth = request.form("fmonth")
fyear = request.form("fyear")
name = request.form("name")
email = request.form("email")
rseat = request.form("rseat")
RTID = request.form("RTID")
tripdate = request.form("tripdate")
rdate = request.form("rdate")

'Get current date and formatting as YYYY-MM-DD

curday = day(date)
curmonth = month(date)
curyear = year(date)

if curday < 10 then
curday = "0" & curday
end if

if curmonth < 10 then
curmonth = "0" & curmonth
end if

curdate = curyear & "-" & curmonth & "-" & curday
chkcurdate = curyear & curmonth & curday

'End formatting

if name <> "" and email <> "" and rseat <> "" then
set conn = createobject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")
set rs1 = server.createObject("ADODB.Recordset")
set rs2 = server.createObject("ADODB.Recordset")
set rs3 = server.createObject("ADODB.Recordset")
set rs4 = server.createObject("ADODB.Recordset")

conn.open condrv

sqlreservation = "SELECT * FROM Trip WHERE TID = " & RTID & ";"
rs.open sqlreservation, conn, 1, 3

sqladdcust = "INSERT INTO Customer (CustName, CustEmail) "
sqladdcust = sqladdcust & "VALUES ("
sqladdcust = sqladdcust & "'" & name & "', "
sqladdcust = sqladdcust & "'" & email & "');"
rs1.open sqladdcust, conn, 1, 3

sqlgetcust = "SELECT CustID FROM Customer "
sqlgetcust = sqlgetcust & "WHERE CustName = '" & name & "' "
sqlgetcust = sqlgetcust & "and CustEmail = '" & email & "';"
rs2.open sqlgetcust, conn, 1, 3
CID = rs2.fields("CustID").value

sqladdbook = "INSERT INTO Book (BDate, BStatus, BPax, TID, CustID, TDate) "
sqladdbook = sqladdbook & "VALUES ('" & rdate & "',"
sqladdbook = sqladdbook & " 'Processing',"
sqladdbook = sqladdbook & " " & rseat & ","
sqladdbook = sqladdbook & " " & RTID & ","
sqladdbook = sqladdbook & " " & CID & ","
sqladdbook = sqladdbook & "'" & tripdate & "');"
rs3.open sqladdbook, conn, 1, 3

sqlgetresrv = "SELECT BID FROM Book "
sqlgetresrv = sqlgetresrv & "WHERE TID = " & RTID & " "
sqlgetresrv = sqlgetresrv & "and CustID = " & CID & " "
sqlgetresrv = sqlgetresrv & "and TDate = '" & tripdate & "';"
rs4.open sqlgetresrv, conn, 1, 3

totalprice = rseat * rs.fields("TPrice").value %>

<table width="100%" border="0" cellpadding="2" cellspacing="2" align="center">
<tr>
<td width="100%" align="center" colspan="2">
<font face="verdana, arial, helvetica, sans-serif" size="2" color="#FF0000">
Reservation Details
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Reservation ID :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(rs4.fields("BID").value & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Name :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(name & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Email :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(email & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Seat Reserved :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(rseat & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Reservation Date :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(rdate & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Trip Date :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(tripdate & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Trip Time :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(rs.fields("TTime").value & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Destination :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(rs.fields("TDest").value & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Transport Type :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(rs.fields("TTranTyp").value & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="50%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Ticket Amount :
</font>
</td>
<td width="50%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%response.write(" RM " & totalprice & ".00" & "<br>")%>
</font>
</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Thank you for your reservation, we will contact you by email shortly.<br>
</font>
</td>
</tr>
<%
conn.close
set conn = nothing
set rs = nothing
set rs1 = nothing
set rs2 = nothing
set rs3 = nothing
set rs4 = nothing
end if%>
<font face="verdana, arial, helvetica, sans-serif" size="2">
<%if trip = "select" or fday = "select" or fmonth = "select" or fyear = "select" then
response.write("Please select destination and time.")
response.write("<br>")
else
TID = request.form("TID")
fdate = fyear & "-" & fmonth & "-" & fday
chkrevdate = fyear & fmonth & fday
end if

if chkrevdate <> "" and chkrevdate < chkcurdate then
response.write("Invalid date, please select again.")
else
valdate = true
end if

if TID > 0 and valdate = true then
set conn = createobject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")
set rs2 = server.createObject("ADODB.Recordset")

conn.open condrv

sqlcount = "SELECT BID, TMaxPax FROM Book B, Trip T WHERE "
sqlcount = sqlcount & "B.TID = T.TID and B.TID = " & TID & " "
sqlcount = sqlcount & "and B.TDate = '" & fdate & "';"
rs.open sqlcount, conn, 1, 3

sqltotal = "SELECT sum(BPax) as Totalpax FROM Book WHERE "
sqltotal = sqltotal & "TID = " & TID & " and TDate = '" & fdate & "';"
rs2.open sqltotal, conn, 1, 3

if not rs.EOF then
maxpax = rs.fields("TMaxPax").value
end if

if not rs2.EOF then
totalpax = rs2.fields("Totalpax").value
end if

conn.close
set conn = nothing
set rs = nothing
set rs2 = nothing

if maxpax <> "" and totalpax <> "" then
seat = maxpax - totalpax
end if

if maxpax = "" then
set conn = createobject("ADODB.Connection")
set rs = server.createObject("ADODB.Recordset")

conn.open condrv

sqlmaxpax = "SELECT TMaxPax FROM Trip WHERE TID = " & TID & ";"
rs.open sqlmaxpax, conn, 1, 3

if not rs.EOF then
maxpax = rs.fields("TMaxPax").value
seat = maxpax
end if

conn.close
set conn = nothing
set rs = nothing

response.write("Maximum Seats : " & maxpax & "<br>")
response.write("Available Seats : " & seat & "<br>")
response.write("Reservation Date : " & fdate & "<br>")
response.write("Current Date : " & curdate & "<br>")
else
response.write("Maximum Seats : " & maxpax & "<br>")
response.write("Total Reserved : " & totalpax & "<br>")
response.write("Available Seats : " & seat & "<br>")
response.write("Reservation Date : " & fdate & "<br>")
response.write("Current Date : " & curdate & "<br>")
end if %>
</font>

<table width="100%" border="0" cellpadding="2" cellspacing="2" align="center">
<form name="reservation" method="post" action="">
<input type="hidden" name="RTID" value="<%response.write(TID)%>">
<input type="hidden" name="tripdate" value="<%response.write(fdate)%>">
<input type="hidden" name="rdate" value="<%response.write(curdate)%>">
<tr>
<td width="100%" align="center" colspan="2">
<font face="verdana, arial, helvetica, sans-serif" size="2" color="#FF0000">
Please fill in the required information for reservation.
</font>
</td>
</tr>
<tr>
<td height="30" width="40%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Full Name :
</font>
</td>
<td height="30" width="60%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<input type="text" name="name" size="50">
</font>
</td>
</tr>
<tr>
<td height="30" width="40%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Email Address :
</font>
</td>
<td height="30" width="60%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<input type="text" name="email" size="50">
</font>
</td>
</tr>
<tr>
<td height="30" width="40%" align="right">
<font face="verdana, arial, helvetica, sans-serif" size="2">
Seat to reserved :
</font>
</td>
<td height="30" width="60%">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<select name="rseat">
<% do while aseat < seat
aseat = aseat + 1 %>
<option value="<%response.write(aseat)%>"><%=aseat%></option>
<% loop %>
</select>
</font>
</td>
</tr>
<tr>
<td height="50" width="100%" align="center" colspan="2">
<font face="verdana, arial, helvetica, sans-serif" size="2">
<input type="submit" value="Submit Reservation">
</font>
</td>
</tr>
</form>
<script language="JavaScript" type="text/javascript">
var frmvalidator = new Validator("reservation");
frmvalidator.addValidation("name","req","Please enter your full name.");
frmvalidator.addValidation("name","alnum","Full Name : Only alphabetic and numeric allowed.");
frmvalidator.addValidation("email","req","Please enter your email address.");
frmvalidator.addValidation("email","email","Email : Please enter a valid email address.");
</script>
</table>
<% end if %>
</td>
</tr>
</table>
</body>
</html>

Roelf
08-22-2007, 10:40 AM
i am too lazy to count lines, which insert is failing, the insert into customer table or the insert into book table. Also, did you check the permissions on the .mdb file as Daemonspyre suggested?

sumidave
08-27-2007, 06:50 AM
i am too lazy to count lines, which insert is failing, the insert into customer table or the insert into book table. Also, did you check the permissions on the .mdb file as Daemonspyre suggested?


Do you know why i got this error types... ?

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Sumi/reservation.asp, line 273

here are the coding from line from line 264 up to 273

conn.open condrv

sqlreservation = "SELECT * FROM Trip WHERE TID = " & RTID & ";"
rs.open sqlreservation, conn, 1, 3

sqladdcust = "INSERT INTO Customer (CustName, CustEmail) "
sqladdcust = sqladdcust & "VALUES ("
sqladdcust = sqladdcust & "'" & name & "', "
sqladdcust = sqladdcust & "'" & email & "');"
rs1.open sqladdcust, conn, 1, 3

please help me to find this solution.... pleaseee..

Roelf
08-27-2007, 07:33 AM
have you checked the permissions on the mdb file yet?

sumidave
08-27-2007, 07:52 AM
have you checked the permissions on the mdb file yet?

i've right click and have a look, it was not checked on read only boxes.

are there any other things i should do ?

Roelf
08-27-2007, 08:10 AM
check the folder where it is in, when updating a access database, a file *.ldb is created. If you are not allowed to create a file in this folder, update fails!

sumidave
08-27-2007, 09:14 AM
there is no file *.ldb created at all... how can i create a file in the same folder.

Roelf
08-27-2007, 10:07 AM
the .ldb file is a file with locking information. It is created just before the update and deleted just after the update. If it is not created, then i suppose there is your problem.

Do you test this locally? Where you are the admin of your filesystem? Or are you testing this online?

sumidave
08-27-2007, 10:17 AM
dear Roelf...

what was really confusing me was...

i doing online bus reservation ticket booking... whatever data that i store into the databases, for example the destination and the prices and time table... all that appear in my webpage when i run the sites, whenever i click the destination ( drop down menu ), it's automatically, show the price and avaialbe ticket/seat and so on...

i even have the admin log in page too, if i key in wrong username and password, thre is a message saying " invalid log in, please try again " .. once i enter the correct username and password.. it's link me to admin mainpage...

why there is problem in my reservation coding.. im having bad headache seacrhing for the solution.

regards,
Sumi

sumidave
08-27-2007, 10:21 AM
i copy and paste the folder into the C:\Inetpub\wwwroot\Sumi

and i've even done the IIS too...and i can run it via the http://localhost/Sumi/index.asp too... all work well... except the reservation details.

maybe i can send you the whole coding via email.. i will zip it and send it to you, maybe you can run it and tell me... where went wrong?

Roelf
08-27-2007, 10:34 AM
so, if i understand correctly, there are some inserts or updates working? Just the reservation inserts are failing?


Currently not at my own workstation so i don't have the tools to run your site on my machine.

sumidave
08-27-2007, 10:52 AM
after i tpye my name and email address to confirm the reservation.. i have to click submit reservation and once i do that.. it's show me error message...
but before i click reservation button, i still can change the destination and the price show automatically.

so, i think ... something wrong somewhere ..and i am not sure what's wrong!

sumidave
08-27-2007, 10:57 AM
maybe you later when you are your workstation, can you run my systems?

because... i dont know where went wrong... if you run the webpage... maybe you know where went wrong.

i am so sorry for disturbing you alot whole day. :-(

Roelf
08-27-2007, 10:59 AM
Do you know why i got this error types... ?

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Sumi/reservation.asp, line 273

here are the coding from line from line 264 up to 273

conn.open condrv

sqlreservation = "SELECT * FROM Trip WHERE TID = " & RTID & ";"
rs.open sqlreservation, conn, 1, 3

sqladdcust = "INSERT INTO Customer (CustName, CustEmail) "
sqladdcust = sqladdcust & "VALUES ("
sqladdcust = sqladdcust & "'" & name & "', "
sqladdcust = sqladdcust & "'" & email & "');"
response.write sqladdcust
rs1.open sqladdcust, conn, 1, 3

please help me to find this solution.... pleaseee..

can you add the red part, execute, then post the result of this display here?

sumidave
08-27-2007, 11:07 AM
still the same error message...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Sumi/reservation.asp, line 273


i am leaving now .. in office... off duty... its 5pm malaysia time now... please send the reply.. i will check it from house.

thanks

Roelf
08-27-2007, 11:11 AM
still the same error message...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Sumi/reservation.asp, line 273


i am leaving now .. in office... off duty... its 5pm malaysia time now... please send the reply.. i will check it from house.

thanks

There should be some output on the page with the query you send to the database. Please post that information here

sumidave
08-28-2007, 07:56 AM
after i click submit reservation... this error message appear...

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Sumi/reservation.asp, line 273


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

Page:
POST 93 bytes to /Sumi/reservation.asp

POST Data:
RTID=16&tripdate=2007-08-29&rdate=2007-08-28&name=Sumitha&email=sumitha_bsc@yahoo.com&rseat=1

Time:
Tuesday, August 28, 2007, 1:53:51 PM


More information:
Microsoft Support

Roelf
08-28-2007, 08:41 AM
sqlreservation = "SELECT * FROM Trip WHERE TID = " & RTID & ";"
rs.open sqlreservation, conn, 1, 3

sqladdcust = "INSERT INTO Customer (CustName, CustEmail) "
sqladdcust = sqladdcust & "VALUES ("
sqladdcust = sqladdcust & "'" & name & "', "
sqladdcust = sqladdcust & "'" & email & "');"
response.write sqladdcust
'rs1.open sqladdcust, conn, 1, 3

then comment the line which produces the error. I really want to see the query which is sent to the database

Are there any databaseconstraints? Like a unique key on the fields you are trying to insert?

sumidave
08-28-2007, 08:54 AM
in my databases.. there is customer, admin, book and trip table... in the

customer = there is Primary key for CUSTID field,
book = there is primary key for BID field
admin= AID
trip = TID

Roelf
08-28-2007, 09:01 AM
is the CUSTID field automatically populated?

What does the query look like after submitting the page?

sumidave
08-28-2007, 09:05 AM
is the CUSTID field automatically populated?

What does the query look like after submitting the page?

i dont understand what you trying to say... if my submit button works... all the data will be store in databases and my admin site too... once i log into my admin pages... i can change from there as well...which i dont have to change it from dabases files ( ticket.mdb )

Roelf
08-28-2007, 09:19 AM
your submit button works, the page responsible for the storage in the database doesn't. If you comment out the line with the rs1.open as i told before, and response.write the query, what does the query look like on the page you see. You should see something line INSERT INTO Customer (CustName, CustEmail) VALUES ('thename', themail');
I want to see what is exactly there. Perhaps you have to view the source of the page (in the browser) to find this query.

sumidave
08-28-2007, 09:43 AM
your submit button works, the page responsible for the storage in the database doesn't. If you comment out the line with the rs1.open as i told before, and response.write the query, what does the query look like on the page you see. You should see something line INSERT INTO Customer (CustName, CustEmail) VALUES ('thename', themail');
I want to see what is exactly there. Perhaps you have to view the source of the page (in the browser) to find this query.



but.. my files saved as reservation.asp... the extension .asp, it wont view the whole coding right?

Roelf
08-28-2007, 09:56 AM
i mean the page as it is in the browser. Put values in the fields on you reservation page. Hit submit. Then the reservation.asp page is going to execute. This will try to execute the sql inserts as you defined them. Comment out the sql insert which gives the problem, response.write the sql. If the page does not show the insert statement as i expect, you should right click the page and then view source. Try to find the insert statement there.

sumidave
08-28-2007, 10:01 AM
i've did that... when i click on the submit.. the error type message that i mention to you earlier is appear...

Roelf
08-28-2007, 10:04 AM
but then the rs1.open line was still executing, hence the error. Now please comment out this line and add the response.write as i told before.
You can also add a response.flush after the response.write to make sure the response.write is indeed pushed to the browser

sumidave
08-28-2007, 10:18 AM
sqlreservation = "SELECT * FROM Trip WHERE TID = " & RTID & ";"
rs.open sqlreservation, conn, 1, 3

sqladdcust = "INSERT INTO Customer (CustName, CustEmail) "
sqladdcust = sqladdcust & "VALUES ("
sqladdcust = sqladdcust & "'" & name & "', "
sqladdcust = sqladdcust & "'" & email & "');"
response.write sqladdcust
'rs1.open sqladdcust, conn, 1, 3



which one should i change / edit the coding?

Roelf
08-28-2007, 10:58 AM
change it into:


sqladdcust = "INSERT INTO Customer (CustName, CustEmail) "
sqladdcust = sqladdcust & "VALUES ("
sqladdcust = sqladdcust & "'" & name & "', "
sqladdcust = sqladdcust & "'" & email & "');"
response.write sqladdcust
response.flush
response.end
'rs1.open sqladdcust, conn, 1, 3
and then, post the output here which is on the screen

sumidave
08-29-2007, 05:14 AM
Dear Roelf,

i've change as what you've suggested... and after i click submit button... it's show all the drop down menu ( the main reservation form ) and this message appear... INSERT INTO Customer (CustName, CustEmail) VALUES ('Sumithamuniyandi', 'sumitha_sc@yahoo.com');

Roelf
08-29-2007, 07:09 AM
sumidave,

there is nothing wrong with that insert statement. So it must be something in the database.

If you can send me the complete site, zipped, i will PM you my mail address. And i will have a look for you.

roelf

sumidave
08-29-2007, 08:21 AM
yes.. i just sent it to you ...

Roelf
08-29-2007, 10:17 AM
you've got mail

sumidave
08-30-2007, 05:08 AM
Dear Roelf....

you've helped me alot... Thanks to you alot...you did a very good response to me...even i've bugging you alot.. hehehe...

All my sites is working well now... thanks for making this happen.. i thought it was because of my coding error...but it's end up on a switch in the security tab... thanks once again...

i will come back to you ... if i've got some other error in future. :-)

take care and have a great day!

bye....



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum