Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 3 123 LastLast
Results 1 to 15 of 40
  1. #1
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts

    Error Type: what's should i do..?

    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

  • #2
    Regular Coder
    Join Date
    Mar 2007
    Posts
    505
    Thanks
    1
    Thanked 19 Times in 19 Posts
    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/...or-process.asp
    To say my fate is not tied to your fate is like saying, 'Your end of the boat is sinking.' -- Hugh Downs
    Please, if you found my post helpful, pay it forward. Go and help someone else today.

  • Users who have thanked Daemonspyre for this post:

    sumidave (08-29-2007)

  • #3
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    thanks for the link... Now i've facing this problem ....

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

  • #4
    Regular Coder
    Join Date
    Mar 2007
    Posts
    505
    Thanks
    1
    Thanked 19 Times in 19 Posts
    Can you post lines 80 - 90?
    To say my fate is not tied to your fate is like saying, 'Your end of the boat is sinking.' -- Hugh Downs
    Please, if you found my post helpful, pay it forward. Go and help someone else today.

  • Users who have thanked Daemonspyre for this post:

    sumidave (08-29-2007)

  • #5
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    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..?

  • #6
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    Quote Originally Posted by sumidave View Post
    what should i do..?
    Provide some more detail. What code is causing that error???
    I am the luckiest man in the world

  • Users who have thanked Roelf for this post:

    sumidave (08-29-2007)

  • #7
    Regular Coder
    Join Date
    Mar 2007
    Posts
    505
    Thanks
    1
    Thanked 19 Times in 19 Posts
    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.
    To say my fate is not tied to your fate is like saying, 'Your end of the boat is sinking.' -- Hugh Downs
    Please, if you found my post helpful, pay it forward. Go and help someone else today.

  • Users who have thanked Daemonspyre for this post:

    sumidave (08-29-2007)

  • #8
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Roelf View Post
    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>

  • #9
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    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?
    I am the luckiest man in the world

  • Users who have thanked Roelf for this post:

    sumidave (08-29-2007)

  • #10
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Roelf View Post
    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..

  • #11
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    have you checked the permissions on the mdb file yet?
    I am the luckiest man in the world

  • Users who have thanked Roelf for this post:

    sumidave (08-29-2007)

  • #12
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Roelf View Post
    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 ?

  • #13
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    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!
    I am the luckiest man in the world

  • Users who have thanked Roelf for this post:

    sumidave (08-29-2007)

  • #14
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    there is no file *.ldb created at all... how can i create a file in the same folder.

  • #15
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    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?
    I am the luckiest man in the world

  • Users who have thanked Roelf for this post:

    sumidave (08-29-2007)


  •  
    Page 1 of 3 123 LastLast

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •