From Linino small C++ Daemon talking to Microsoft SQL Server/Web Server

Official Hardware Classic Yún
1

Hello,

What is the best way a small C++ Daemon running on Linino side to make a call:

  1. to Microsoft SQL Server and get a row information from a table
  2. to HTTP - Web Server to receive some messages ( running outside Yun's network & Not using Temboo API)
    Please any insights is highly appreciated: Are there any limitations of the firewall or Port issues around Linino. Thanking all in advance,

High Regards,

BRE

2

BREL:
2. to HTTP - Web Server to receive some messages ( running outside Yun's network & Not using Temboo API)

I could not find Temboo API for Microsoft SQL, in other word Temboo has no support.

At Openwrt no support for Microsoft SQL directly, Microsoft has no support mssql client lib for mips .

Still have 3 ways to do;-

  1. Python pyodbc ( cross compile yourself)
  2. Python pymssql ( cross compile yourself)
  3. Php pdo with mssql driver ( cross compile yourself)
3

Hi Sonnyyu & all,

Thank you very much for your reply. This certainly helps.

What would be best way to make simple http call from Daemon to some web server to receive some messages ( running outside Yun's network & Not using Temboo API) : ( Is making use of cURL is the best choice or the only choice available )

Please any insights is highly appreciated: Are there any limitations of the firewall or Port issues around Linino.
Thanking all in advance,

4

I don't know if it is the best way, but using curl is simple

curl http://ernstc.dk/yun_db.php

This will retriev one row from a database hosted on a webserver somewhere in the world.

It is a mySql database, but that could be any database

5
  1. Example of Native GCC for Yun - #4 by sonnyyu - Arduino Yún - Arduino Forum