Emergergency- Can someone please help

Results 1 to 3 of 3

Thread: Emergergency- Can someone please help

  1. #1
    Adrian Guest

    Default Emergergency- Can someone please help

    Hi,<BR><BR>I&#039ve got a system whereby visitors to my site can visit other sites in my links page. I have all of these pages urls contained in a database with id, name, county and hyperlink_ej(URL)fields. This link system was working ok on my old server but having switched companies the following error occurs when i click on one of these links.<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <BR><BR>/englishasp/link_e.asp, line 13 <BR><BR>This is link_e.asp<BR>&#060;%@Language=VBScript%&#062;<BR> &#060;%<BR>Response.Buffer = True<BR>%&#062;<BR>&#060;%id = Request.QueryString("ID")<BR>Set Conn=Server.CreateObject("ADODB.Connection")<BR>Se t RS=Server.CreateObject("ADODB.RecordSet")<BR>Conn. Open "DSN=linkspage"<BR>SQLString = "Select * From links Where ID = &#039"&id&"&#039"<BR>RS.Open "links", Conn, 0, 2, 2<BR>RS.Filter = "ID = " & id<BR>RS("Click_Counter") = RS("Click_Counter") + 1<BR>RS.Update<BR>Response.Redirect "http://" & RS("hyperlink_ej") & ""<BR>RS.Close<BR>Set RS = Nothing<BR>Conn.Close<BR>Set Conn = Nothing<BR>%&#062;<BR><BR>The DSN is definetly set up. Line 13 is "RS.Update".<BR>Is this happening because Microsoft frontpage extensions mightn&#039t be set up. I&#039m totally lost. This is really urgent.Can someone please help.<BR><BR>Adrian<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Emergergency- Can someone please help

    If it just started after the move, my first guess would be that write/update permissions are not set up correctly for the directory where your database is located, so you are getting a security violation. Check with your new hosting company on this.

  3. #3
    Timothy Narron Guest

    Default RE: Emergergency- Can someone please help

    Change the RS.open line, it should read:<BR><BR>RS.Open SQLString,Conn,0,2,2<BR><BR>Instead of<BR>RS.Open "links", Conn, 0, 2, 2<BR><BR>That looks like the problem to me.<BR>Timothy Narron

Posting Permissions

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