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

You can run .NET apps on Win IOT but there are some restrictions as Windows 10 IoT Core only supports a subset of the Win32 and .Net APIs.  When you build an app for IOT it gets transferred to the Pi as part of the build process.

I've not tried it out yet but it should all be explained here https://developer.microsoft.com/en-us/windows/iot

You are a bit limited for database options on Windows IOT although SQLite does seem to be supported Using SQLite in Windows 10 IoT Core – Chris Briggs' Blog

alternatively store your data remotely.

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?

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.

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..

Access is a very old application, I was using nearly 20 years ago when I first started work. It's also a desktop application so it's quite heavy weight by modern standards.

We moved across from Access to VB+SQL server about 15 years back, it was a big job but of was also worth it. We've moved again since then to .Net+SQL server but are petty much database agnostic now.

I would recommend porting across to an alternative database, the technologies for connecting to Access (JET and COM) are being phased out if they are not already unsupported.

If you want to use Win10 IOT then SQLLite could be a good choice, or Azure if you want to offload the DB to a server.

Some more on SQLLite

https://blogs.windows.com/buildingapps/2016/05/03/data-access-in-universal-windows-platform-uwp-apps/#XSHq0kcvOYKS6PkA.9…

One of the key technologies for accessing databases on .Net Entity Framework has a cut down version for IOT core.

https://blogs.msdn.microsoft.com/dotnet/2016/06/27/entity-framework-core-1-0-0-available/

One thing I have learnt over the last 20 years is not to get too personally attached to particular technologies as you often find support is dropped or the new version is incompatible. You've probably got a couple of years before Access becomes a real problem to support.

if ms wants to phase it out, why are they still selling ad including only ms Access in the office platform?

For me the biggest and best reason is that there is no server aplication running on my customers networks. Just locally a db file and make ure it can  be "seen" by all indivudual users. as far as i know, all sql based db's have to run a (sometimes even costly) db server..

or am i wrong? (pease do not tell me that mssql can be downloaded for free up till 5 users. I know, but it still has to run in their netswork as a server.)

Because of the sensative  data, I also can not use a web based sql db....

If you know a good alternative for that, I am very curious to know, beacause I am for sure not a supporter of the acces db, because untill now, it makes my life rather more difficult than easier.... So which db I can adress by just using a pluging or something in my vb.net program without installing servers...

>if ms wants to

I've given up trying to second guess Microsoft.

>all sql based db's have to run a (sometimes even costly) db server..

No, that's not the case. There are options that don't have a separate server or service. Here's the ones that I know about, there may be others.

For desktops/laptop based applications there is SQL Server Express which is a free edition. It runs locally with your application. We use this for ship-based applications where there is limited infrastructure and intermittent connectivity.

For the IOT edition there SQLLite, also free, this would also run on desktops, phones etc.

If you use something like Entity Framework(https://blogs.msdn.microsoft.com/dotnet/2016/06/27/entity-framework-core-1-0-0-available/ ) or Massive ( https://github.com/FransBouma/Massive ) then you can swap out different databases without changing code as long as you read your configuration settings from a file.

   Hey if you want to know about

how to fix connections to bluetooth audio devices and wireless displays in windows 10  then for this you have follow some basic rules and regulations that will be help you when you will connect the bluetooth with windows 10.