Results 1 to 2 of 2

Thread: urgent!!!!

  1. #1
    Join Date
    Dec 1969

    Default urgent!!!!

    hi <BR>Uptill now i have been working in oracle only.But in one of my application i have to use ms acces as database.I simply wantedto fire a insert query. For that i have first made a dsn both on my machine as well as on server.<BR>then i have written the following code<BR><BR>et cmd=Server.CreateObject("ADODB.connection")<BR>cmd .open " dsn=nafisa"<BR><BR> cmd.execute"insert into feedback values(&#039;" & valueForvar1 &" &#039;,&#039;" &valueForvar2 &"&#039;,&#039;" & valueForvar3 &"&#039;)"<BR><BR>but it is giving me error like this<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file &#039;(unknown)&#039;. It is already opened exclusively by another user, or you need permission to view its data. <BR><BR>can anyone help me out by just giving me code as how to connect and how to fire a simple insert query<BR>

  2. #2
    Join Date
    Dec 1969

    Default see this


Posting Permissions

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