MS SQL Server 2012/2016

Projects Programming
1

Hello, I use Arduino UNO R3 in my project.
I have one big problem for me and I can`t found anything about it.
I read data from DHT22 (Temp, Humidity) sensor and I want to send data via WiFi modul to MS SQL database.
Are there any library about this? Now I found different methods how to send data to My SQL (XAMP) and nothing for Microsoft DB.
My clients use MS SQL and they want to save sensor data there.
If anyone know something about this problem please write here.

Thank you.

Best regards.
Arduino man :slight_smile:

2

You've got to start looking at Microsoft's server side scripting languages (ASP (VBscript) etc.)
Create an HTML/ASP page to be hosted on a MS IIS server which your UNO application can access via WifI and which posts the Temperature and Humidity data to a table in the MS SQL database using commands like SELECT, INSERT etc..

3

You can let your wifi module make a GET/POST request to a php script that you host. So for exemple you let the module surf to : 'www.mywebsite.be/script.php?humidity="VAL1"&temp="VAL2"' and in the script you type :

	if(isset($_GET["humidity"]) && isset($_GET["temp"])){
	$humidity = $_GET["humidity"];
        $temp = $_GET["temp"];
	$data ="INSERT INTO DATA (hum,temp) VALUES $hum,$temp
 	if (!mysqli_query($verbinding, $data)) {
			echo "Error: " . $data . "
" . mysqli_error($verbinding);
		}
	}
4

If the customer is a 'Microsoft' user, the chances are that PHP is not available there. Anyway, you'd still be left with the problem of finding a connector in PHP for an MS SQL Server 2012/2016

5

I ment hosting it on a domein wich can run php, mysql and so on. You can get one for free on http://www.bplaced.net/?location=menu.