Information générale
Catégorie:
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement