Page 1 of 1
SQL database in external computer
Posted: Mon May 13, 2013 4:15 am
by jmsmoreira
Hi,
I'm using a T10A. I can do SQL queries to database of the screen.
Now I have a database in an external computer connected to the HMI network.
How can I do (or is it possible) a query to that database?
What kind of path should I use,if for instance the T10A is 192.168.0.100, and the computer with the database is 192.168.0.101?
Re: SQL database in external computer
Posted: Mon May 13, 2013 5:13 am
by Edmund
I´m pretty sure that .Net Compact Framework (T10A) only supports local stored SQL Server Compact Edition (CE) instances, Not remote or a real SQL Server.
If you need to exchange data you will probably need to build a web service that you communicate thru... or upgrade to TxC where you have the full .Net Framework available.
Re: SQL database in external computer
Posted: Tue Feb 18, 2014 5:42 am
by mustafa
Hi Edmund,
Do you have example about web service because i didn't find any example in this forum?
Re: SQL database in external computer
Posted: Thu Apr 10, 2014 2:13 am
by ngi
You'll have to create a standard Web service using visual Studio and put it on a Web server (IIs for example). You'll find tons of examples of it.
Next, you'll have to create a Windows Mobile app in Visual Studio 2008 Pro (not supported afterwards in VS2010). Beware, a Windows Mobile, not Windows Phone app.
This WinMobile app will register the Windows Service methods. It'll give you a dll which you'll import into your iX project for Windows CE based T7A or T10A/B.