Actions
Forum Thread Details
  • State Suggested Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 6 subscribers
  • Views 2027 views
  • Users 0 members are here
Related

Starting with Raspberry Pi 3 with Windows 10 IOT and access db engine

amateurtje

Hello All,

 

I am new here and the raspberry PI, Win10 IOT etc are all very new to me.

 

I have a system running which is made in vb.net and uses a serial box to read io ports. Information regarding this is stored in a access database. For a lot of reasons is this the easiest to use instead of other db's.

My questions are:

- Is it easy/do-able to transfer my current program developed in Visual studio to a program for the Win 10 IOT?

- I use a accessdatase engine plugin. Will I be able to use this on windows IOT?

          - or is there another way to store data in an access database?

 

Who can help me getting started?

 

Greetz

Amateurtje

Parents Reply Children
  • 0 in reply to Workshopshed

    hi andy,

     

    Thanks for te answer.

     

    While the complete system is already build around access databases, It is a big job to start using another db-system. This is a problem. Crazy.. A windows 10 versions (although IOT) that can not handle an access db......

     

    What do you mean with store your data remotely? Than I still have to comunicate with the access db in order to store my data in that?

  • 0 in reply to amateurtje

    Access is effectively a desktop solution so it's not surprising that it does not work on an embedded platform such as IOT. I was a little surprised that Access was still supported on any platform, I had to double check that before answering.

     

    By remotely I mean having another machine that can accept calls to save the data, typically we use SQL Server but MySQL or Azure DB would also work. Access would not work in this fashion on IOT as it would still require the Microsoft Jet Database Engine to access the file.

  • 0 in reply to Workshopshed

    that is completely dissapointing. So they basically made a useless os based on a useless system. The Access database has huge advantages over  mysql systems etc but they can not be used. So all developments can better be done normally and we use small pc's like atom etc. The only thing we need for that above the useless raspberry pi is that it has no GIO ports....

    I bought 1 for test before introducing them into my system but that was a waste f money. Yes, i know, my own fault. I should have asked this question before buying but I finally that there was something usefull in the market.

     

    EDIT:

    Thanks for the info..