Solved

3G Modem and Assembly to TCP IP

Posted on 2010-09-03
4
1,480 Views
Last Modified: 2013-12-21
I need to make a device which sends some proximity card info to the mysql server over the 3g modem
Is there any sample application which records any info to a Database over this system with a microchip

Thanks
0
Comment
Question by:3XLcom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 3

Accepted Solution

by:
gremwell earned 500 total points
ID: 33607361
I am not aware of a sample application for this specific task, it probably does not exist. I can give you with some input to help you put such a system together.

Do you have some particular proximity sensor, 3G modems, MCU, and database, and transport between MCU and the server in mind?
What are your criterias for optimal solution? How important is the cost of the device, communication costs, reliability of the data transfer.

Regarding the transport, you have several options:
1) Establish TCP/IP connection between PIC and Internet-connected server. The sever will receive messages over TCP or UDP and store it in the database.
The following variation are possible on MCU side:
 a) Use 3G modem with RS232 interface to interface it to PIC and implement PPP+TCP/IP stack + your application protocol in MCU.
 b) Use 3G modem with built-in TCP stack, which are probably more expensive. I never used those, you could follow up on this thread http://www.edaboard.com/thread39194.html

2) Transport data over SMS. MCU can issue necessary AT commands to a 3G modem over RS232 interface to make it send SMS and confirm the reception. On the server side the following variations are possible
 a) Attach a 3G device (a mobile phone, or a data card) directly to the server and read incoming SMS'es with AT commands, and save it in the database.
 b) Use SMS-to-email (or to SNPP, or to other suitable protocol) gateway. Your server will receive the messages and store it in the database.

I can give you more details on the solutions outlined above if necessary.
0
 
LVL 12

Expert Comment

by:HappyCactus
ID: 33611823
Telit ( http://www.telit.com ) have many 2/3G embedded modules that can be programmed in python (look for -py suffix products). With python you can implement some (simple) script to acquire data from an external board and send it to a server with some internet protocol (http for example).
Some module also have some GPIO (General Purpose I/O) that can be used to interface some simple sensors and actuators (relais). And a serial port, an i2c and spi module (the two latter do not work reliably, however).
I think that this is the perfect solution to your problem, if the interfacing with your sensor board is serial or a simple digital I/O.

Hope that helps.
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Need WiFi? Often, there are perfectly good networks that don't have WiFi capability - and there's a need to add it.  - Perhaps you have an Ethernet port into a network but no WiFi nearby. - Perhaps you have a powerline extender and no WiFi at the…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This Micro Tutorial will show you how to maximize your wireless card to its maximum capability. This will be demonstrated using Intel(R) Centrino(R) Wireless-N 2230 wireless card on Windows 8 operating system.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question