can vb.net 2005 support visual fox pro database & tables????

i had symbol mc50 pocket pc. And i m using vb.net 2005. Can it support visual fox pro database & tables. Can giv me some sample code that manage add, delete, update, dataset, connection string. Thanz



Answer this question

can vb.net 2005 support visual fox pro database & tables????

  • av.arce

    There are SQL Server 2000/2005 and SQL Server Mobile providers for NETCF as well as some 3rd party providers which you can find using any internet search engine.

    There are no ODBC (not supported by Windows CE at all) or OLEDB ADO.Net providers for NETCF. While OLEDB is supported by the OS, there's hardly an abundance of OLEDB drivers for it, so such provider probably won't do you any good should it be available.

    Using WS as a proxy is your best bet.

    By the way, I’m not even sure if VFP allows for remote connections at all (and I’m not counting DB file on network drive).



  • Handschuh

    i had facing one problem that is i cant create new project. The status bar written "creating project DeviceApplication1 project creation failed". I had see all the forums disscuss that IE7.0 can effected, but my pc doesnt install IE7.0. So what is the solution.

    Besides, when first time i install the visual studio 2005, there will have "7494682B-37A0-11D2-A273-00C04F8EF4FF" of error.

    Thanz.



  • Squirrel70

    Sort answer: no, you can not as there's no NETCF compatible ADO.Net provider for VFP.

    Longer answer: go through Web Service as proxy to connect to VFP (or any other desktop compatible database), please search for details.



  • iampedro

    Dear Ilya Tumanov,

    Ok, so the NETCF compatible with what kind of ADO.Net provide

    I had try import system.data.oledb. But cant work. so what is the solution


  • Helen Cool Granny

    If you mean Access database, solution is the same as with VFP - go through WS.

    Or you might be able to use this if you don't need direct access to Access db:

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=678930&SiteID=1



  • Scott McKeown

    Good to recognize you at here, You are so professional, But now i system is using access. What is my solution


  • can vb.net 2005 support visual fox pro database & tables????