Bharat,
This is VB code that you need to translate to VFP. Try something like this:
#INCLUDE ADO.H
oConnection = CreateObject("adodb.connection")
oRecordSet = CreateObject("adodb.recordset")
oConnection.Open("Provider=MSDASQL;SERVER=HDS_SQLSERVER1;DATABASE=nms_jfm;DRIVER={SQL SERVER};uid=sa;pwd=sa")
oRecordSet.Open("select * from _4_CLAIM_DBF_TEMP", oConnection, adOpenKeyset, adLockOptimistic, adCmdText)
HTH
>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
Daniel