Information générale
Catégorie:
COM/DCOM et OLE Automation
Remove the error trap or implement Terry's suggestion to obtain the source OLE error from ADO, then post it here.
Your code looks good, assuming your connection is open and the "Photographers" table exists. The only thing there is that adOpenDynamic is not compatible with adUseClient, but usually ADO ignores that and adjusts the CursorType setting.
>I am trying to upload data from VFP tables into SQL server using ADO
>
>I can open the connection, but opening the recordset gives an error.
>
>My code is something like this.
>
>**
>local ERR
>on Error ERR = .T.
>With oNewphotoRS
> .ActiveConnection = oConnection
> .Source = "Photographers"
> .CursorLocation = adUseClient
> .LockType = adLockBatchOptimistic
> .CursorType = adOpenDynamic
> .CommandType = adcmdTable
> .Open()
>EndWith
>**
>IF Err
> WAIT WINDOW "Error opening recordset"
>ENDIF
>**
>
>What I am doing wrong here. I am using VFP 7.
>
>TIA
>
>Alhad
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