I need a connector to connect from a application running on Windows CE machine to a MySQL Server. Is there anything like this for both ARM and x86?
Thank you
riahc3 50 Â Team Colleague
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Haven't been able to find any yet. I think your best bet is to create a webservice as intermediairy.
riahc3 50 Â Team Colleague
Haven't been able to find any yet. I think your best bet is to create a webservice as intermediairy.
This actually could be a intresting solution.
I would run this web service on a Windows Embedded Compact 7 running on a ARM processor though so Im not completely sure its possible BUT I would be willing to give it a chance.
What steps do you suggest I do?
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Does your MySQL run on a server that has also a web server running? If so, I'd suggest building a simple REST server, to accept an incoming request, get the required data from MySQL and return it (e.g. in JSON or XML format).
The CE machine would only be a client, and getting a web request should be straightforward.
riahc3 50 Â Team Colleague
The MySQL server runs on a Synology NAS which I BELIEVE also has the ability to run as a web server.
How do you find how exactly I would set up a REST server? I heard of JSON but IM not sure if its related or not.
What about SOAP? Would this work?
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
What about SOAP? Would this work?
Yes, that works too.
riahc3 50 Â Team Colleague
Yes, that works too.
So basically I would build a "SOAP server" and then my application running in Windows Embedded Compact 7 would call it and it would get data?
Is this the idea?
I looked up how to make a SOAP server and its kind of....confusing..
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Is this the idea?
Yes.
I looked up how to make a SOAP server and its kind of....confusing..
That's why I suggested a REST server at first, the implementation and usage is much simpler.
riahc3 50 Â Team Colleague
That's why I suggested a REST server at first, the implementation and usage is much simpler.
The thing is that the IDE I use for developing a embedded app on Windows CE does comment about using SOAP but it comments nothing about REST so Im not completely sure it is compatible
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
What IDE is that, Visual Studio? Talking to a REST service requires not much more than a (Http)WebRequest.
riahc3 50 Â Team Colleague
a
What IDE is that, Visual Studio? Talking to a REST service requires not much more than a (Http)WebRequest.
We are talking about a embedded industrial application. Nothing on a PDA, POS, smartphone, etc :)
VS does not do embedded devices anymore I believe
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
VS does not do embedded devices anymore I believe
You'll need VS2008 I think. We use it still to program handheld scanners.
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
Have you tried ADOCE DLL? I haven't used it in several years now but it worked about 10 years ago.
riahc3 50 Â Team Colleague
Im trying to download it but it gives me a .exe which I do not trust.
Any place to directly download those .dll?
riahc3 50 Â Team Colleague
The web service route has been discarded.
That "ADOCE DLL" seems intresting. I just need the files.
riahc3 50 Â Team Colleague
riahc3 50 Â Team Colleague
The dotConnect seems to work (because it accepts the connection) but it has some stupid license issues that dont allow me to use it.
So right now we are with SOAP (which Im trying to implement but I dont see a good way how or at least Im not understand how to do it, any tutoral?) or the ADOCE DLL that was mentioned but I havent been able to find the DLLs.
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
What's your language choice for the SOAP server? Would make finding a possible tutorial easier.
riahc3 50 Â Team Colleague
What's your language choice for the SOAP server? Would make finding a possible tutorial easier.
http://msdn.microsoft.com/en-us/library/ms862153.aspx
Personally, I perfer C#. Realistically, I want the easiest one.
riahc3 50 Â Team Colleague
For example, lets make a simple web service app that I put two numbers, adds it up and it gives me the result of the sum :)
What is the best way to implement this step-by-step? Because Im seeing a connector is impossible.
riahc3 50 Â Team Colleague
If it helps the web service and the database will be on the same device.
riahc3 50 Â Team Colleague
The device would be a basic Synology NAS; Apache, PHP, etc.... Just to note some of the technologies that would be avaliable.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.