Take a look at an article 'ADO Jumpstart for Microsoft Visual FoxPro Developers' by John Petersen at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp

>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