General information
Category:
Internet applications
Two suggestions:
1. Turn off backgroundfetch
2. Send a SET REPROCESS command to the driver before issuing your update. Something like: objConn.execute "Set Reprocess to 5 seconds",,1
>We get a Cannot Update Cursor error at random times when writing to a visual foxpro table on as ASP page. We don't have this problem on our development machine (NT 4.0 workstation) but once the files are uploaded, the error does pop up on the nt server. The weird thing is that it does this seemingly at random. The directory where the tables are located has read/write permissions. We use a dsn less connection with the following way:
> strSQL = UpdatePayorFields()
> adCmdText = 1
>
> 'create connection object
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=" &server.mapPath("../Data/Student Account Data/"&lcDir) & ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=No;Deleted=Yes;"";Locale Identifier=1033;"
> objConn.Open
>
> 'Create command object
> set objCmd = Server.CreateObject("ADODB.Command")
>
> 'set command object properties
> set objCmd.ActiveConnection = objConn
> objCmd.CommandText = strSQL
> objCmd.CommandType = adCmdText
>
>
> 'Execute the command
> objCmd.Execute
>
> set objCmd = Nothing
> objConn.Close
> Set objConn = Nothing
>
>Like I said, sometimes it works and somtimes I get a cannot update the cursor error. Any help would be appreciated.
>
>Marcel
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only