VisualFoxPro and Access or Visual Basic
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: VisualFoxPro and Access or Visual Basic

  1. #1
    Join Date
    Apr 2004
    Location
    Montréal
    Posts
    2

    Unhappy 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 !!!

  2. #2
    Join Date
    Apr 2004
    Location
    Montréal
    Posts
    2
    nobody know the anwser ???
    i'm on windows 2k with visual basic 6.0 or access 97

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center