I am using the VFP ODBC driver with the System DSN set to "Free Table Directory."

I am attempting a very simple insert using ASP /VB script on an NT server at my web server (clever.net is our host).

<% Set oConn = Server.createObject("ADODB.Connection")
oConn.open "quiz1" 'System DSN name

strSQLStatement = "INSERT INTO quiz1 (DateEntry, TimeEntry, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10, Q11, Q12, Q13, Q14, Q15, TOTAL) VALUES ('"& strDate &"', '"& strTime &"', "& valr1 &", "& valr2 &", "& valr3 &", "& valr4 &", "& valr5 &", "& valr6 &", "& valr7 &", "& valr8 &", "& valr9 &", "& valr10 &", "& valr11 &", "& valr12 &", "& valr13 &", "& valr14 &", "& valr15 &", "& totval &");"%>
<% oConn.Execute(strSQLStatement) %>
<% oConn.Close %>
<% Set oConn = Nothing %>


This procedure works fine on my 95/98 machine. The dbf is updated and the page is returned with the calculations.

But the response from the web server is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
/qlistenc2.asp, line 510

I have tried to recreate this problem on my local machine. No luck.

I use WSFTP to copy the dbf file to the correct folder. I have checked what permissions I can.

And I am very sad.

(http://faceway.com/pages/qlistenc2.htm is the calling page)

Any thoughts?

Jesse