Solved

3G Modem and Assembly to TCP IP

Posted on 2010-09-03
4
1,472 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL Sub-Select Query Returning Duplicate Result 7 51
Wifi addin for wireshark? 5 49
i am unable to add data to mysql database 6 55
Dynamic Table mySQL stored procedure 5 37
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
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…

730 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