Welcome Guest ( Login | Register )



All times are UTC - 7 hours [ DST ]



Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: SQL database in external computer
PostPosted: Mon May 13, 2013 4:15 am 

Joined: Mon Apr 23, 2012 7:03 am
Posts: 28

Offline
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?


 Profile  
 
 Post subject: Re: SQL database in external computer
PostPosted: Mon May 13, 2013 5:13 am 
User avatar

Joined: Thu Nov 29, 2012 2:27 pm
Posts: 92

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

_________________
Edmund Andersson

AITECH AB

Part of Beijer Integrator Group


 Profile  
 
 Post subject: Re: SQL database in external computer
PostPosted: Tue Feb 18, 2014 5:42 am 

Joined: Fri Jun 28, 2013 3:28 am
Posts: 2

Offline
Hi Edmund,
Do you have example about web service because i didn't find any example in this forum?


 Profile  
 
 Post subject: Re: SQL database in external computer
PostPosted: Thu Apr 10, 2014 2:13 am 

Joined: Fri May 03, 2013 3:50 am
Posts: 3

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


 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 7 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron