Go Down

Topic: Connect MKR1000 directly to SQL server (Read 780 times) previous topic - next topic

Bjain

Hello,
Is it possible to send data from MKR1000 to a table in SQL server directly and also read data from SQL server tables using the SQL queries.

baqwas

There is the MySQL Connector/Arduino library by Dr Charles Bell but it is limited, as the name implies, to MySQL instances. Works rather well, IMHO.  :)

Reference forum: https://forums.mysql.com/list.php?175

Bjain

I need it specifically for MS SQL Server.

baqwas

Sorry for not being very helpful here because I am unaware of any MS SQL connector for the board. The convoluted way to solve your predicament would be use an intermediate hop (or traffic cop) with a platform that has the direct connectivity to MS SQL instances and equally communicates to your board via one of the standard protocols (an extra hop, an extra headache may be your comment!).

baqwas

Two other points that I would like to mention are:
  • If you exercise control over the MS SQL instance you can explore the data exchange interfaces (e.g. web services, XML and others)
  • Microsoft Azure will give you a gateway to MS SQL but at a price after the trial period is over

Bjain

Thanks for the suggestions..
I will check which one works out best.

Go Up