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