update query problem

Results 1 to 3 of 3

Thread: update query problem

  1. #1
    rahul Guest

    Default update query problem

    hi guys<BR>i am facing one problem in which<BR>i have database on local machine in which i can give update query and it works where as if i put same database on network server then update query doesn&#039;t work.can anyone tell me what is the problem.or how should i specify server settings.<BR>here is query i am using<BR><BR>&#060;%dim DbConn,RS<BR>set DbConn = Server.CreateObject("ADODB.Connection")<BR>dbConn. Open "provider=microsoft.jet.oledb.4.0;data source=//server/folder/contacts.mdb"<BR>set RS = server.createobject("adodb.recordset")<BR>RS.open" UPDATE Contacts SET " &_<BR>"surname=&#039;" & request.form("txtsurname") & "&#039;, " &_<BR>"firstname=&#039;" & request.form("txtfirstname") & "&#039;, " &_<BR>"middlename=&#039;" & request.form("txtmidname") & "&#039;, " &_<BR>"address=&#039;" & request.form("txtaddress") & "&#039; " &_<BR>"WHERE contactID=" & request("contactID"),Dbconn,0,1<BR><BR>let me know what specification i should do to run my update query on server database.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: update query problem

    As far as I know, you can&#039;t use OLEDB over UNC shares (besides which, you need *backslashes*, not forward slashes for a UNC address.<BR><BR>a mapped network drive, however, is a different proposition. try mapping the drive to a drive letter and see if it works then.<BR><BR>j

  3. #3
    prashanth Guest

    Default RE: update query problem

    use server.request(database) and try it would work<BR>

Posting Permissions

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