Connect MKR1000 directly to SQL server

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.

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. :slight_smile:

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

I need it specifically for MS SQL Server.

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!).

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

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