(Could this be a permissions issue?)
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" 'the database's System DSN
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