How do I update a Visual FoxPro database using ASP

Results 1 to 2 of 2

Thread: How do I update a Visual FoxPro database using ASP

  1. #1
    Join Date
    Dec 1969

    Default How do I update a Visual FoxPro database using ASP

    I have written an ASP script that should update a Visual FoxPro database. When I try to execute the script I get the following error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e37&#039; <BR><BR>[Microsoft][ODBC Visual FoxPro Driver]File &#039;tmpforms.dbf&#039; does not exist. <BR><BR>/ACSONLINE/Enroll.asp, line 238 <BR><BR>However, my database does exist.<BR><BR>My connection string looks like this:<BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR><BR>obj Conn.Open "Driver={Microsoft Visual FoxPro<BR>Driver};SourceType=DBF;SourceDB=\servern ameacsonline mpforms.dbf;"<BR><BR>I place my form information into variables that I declared in the script. Then I do the following:<BR><BR>sql="INSERT INTO tmpforms (Coname,Sfnum,Division,Fpassword,<BR>sql=sql & " VALUES "<BR>sql=sql & "(&#039;" & strEmployerName & "&#039;,&#039;" & strSFNum & "&#039;,&#039;" & strDivision & "&#039;,&#039;" & strPassword & "&#039;)"<BR><BR>Then I execute the sql by doing this:<BR><BR>objConn.Execute sql<BR><BR>This is where I am getting the error. I have my script, html form page, and Visual FoxPro database located in the same folder on my server. Is this OK?<BR><BR>Is there some type of bug between ASP and Visual FoxPro? The reasonI ask is because I can get this code to work using an Access database. If there is a bug, how do I fix it?<BR><BR>Any help anyone can provide would be great.<BR><BR>Thanks!<BR><BR>Jai Douglas<BR> <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Where did you get that connection???

    FoxPro isn&#039;t a DB server, like SQL Server is. It&#039;s much like Access, just a DLL that runs in process with ASP.<BR><BR>The connection string should look something like this:<BR><B R><BR><BR><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