>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