General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only