VisualFoxPro and Access or Visual Basic
i have visualfox pro table and i want to connect to him. For read, not problem. But for write there is the problem
i read on microsoft web site only RDO connection can write in foxpro table
http://support.microsoft.com/defaul...&NoWebContent=1
i try that
add "Microsoft remote Data Object 2.0" in reference and that
-----------------------------------------
Private Sub Form_Load()
'
' Using a DSN-less connection to open a free table
'
cn.Connect = "SourceType=DBF;" _
& "SourceDB=C:\Vfp\Samples\Data;" _
& "Driver={Microsoft Visual FoxPro Driver}"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection "rdDriverNoPrompt"
SQL = "select * from customer" 'this should be a free table
Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)
rs.MoveFirst
Text1.Text = rs(0)
Text2.Text = rs(1)
End Sub
------------------------------------------
but that doesn't work i receive :
Run-time error '429':
ActiveX compoment can't create object
i try register again ... nothing (regsvr32 msrdo20.dll) and reboot after
i try VB6CLI.exe ..... nothing
http://support.microsoft.com/defaul...kb;EN-US;194751
Please help me !!!:confused:
