problem in update..

Results 1 to 2 of 2

Thread: problem in update..

  1. #1
    Join Date
    Dec 1969

    Default problem in update..

    hi guyz,<BR>I have a problem in updating my database.<BR>select queries work fine.<BR>I am using MS Access Database and ADODB Drivers with DSN.<BR>The connection is open and i am able to execute select statements on this ASP page but not able to update DB.<BR>Here is my code i am using to update DB.<BR>Please let me know where i am wrong.<BR>My code is below:<BR>---<BR>set conn=server.createobject("ADODB.connection")<BR>co nn.Open "DSN=HIGH"<BR>sqltemp="update emp set name=&#039;"&uname&"&#039; where empid="&clng(x)&""<BR>conn.Execute(sqltemp)<BR>----<BR>The error i get is:<BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.<BR><BR>Thanks in advance.<BR>Warm Regards,<BR>ms

  2. #2
    Join Date
    Dec 1969

    Default look in the FAQs

    FYI the folder which contains your database is not writable by the anonymous web user.<BR><BR>j

Posting Permissions

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