General information
Category:
Active Server Page
I can't see where you are setting the cursor location to adUseClient,
that is important for web server applications to prevent bugs.
>We get a Cannot Update Cursor error at random times when writing to a visual foxpro table. 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