Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I am trying to use ADO(Active Data Objects with Visual Fox Pro. I have downloaded the SP5.o from Microsoft Site. Now when I write the statement to declare the connection like
>
>Public cnSQL As New ADODB.Connection
>Public rsWare As New ADODB.Recordset
>cnSQL.Open "Provider=MSDASQL;SERVER=HDS_SQLSERVER1;DATABASE=nms_jfm;DRIVER={SQL SERVER};uid=sa;pwd=sa"
>rsWare.Open "select * from _4_CLAIM_DBF_TEMP", cnSQL, adOpenKeyset, adLockOptimistic, adCmdText
>
>I am getting the program error in very first line
>Public cnSQL As New ADODB.Connection saying
>
> " MUST BE A VARIALE OR ARRAY"
>
>
>Thanks
>Bharat
Have you included ADOVBS.INC in your header or at least set the ado properties to equivalent numeric values?
Tom
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