Page 1 of 1

Connect ESP32 to MS SQL Server

Posted: Fri Sep 20, 2019 9:21 pm
by tomcat2900
Hello!

How can I connect ESP32 to a Microsoft SQL Server for writing and reading data from a database ?

Thank You !

Re: Connect ESP32 to MS SQL Server

Posted: Fri Sep 20, 2019 9:40 pm
by tommeyers
Many ways. I use MQTT on my server, subscribe in Java publish from esp32.

You could also use nodered and JavaScript.

You could also use some language to listen on a port and write to SQL server.

Re: Connect ESP32 to MS SQL Server

Posted: Fri Sep 20, 2019 9:50 pm
by tommeyers
Many ways. I use MQTT on my server, subscribe in Java publish from esp32.

You could also use nodered and JavaScript.

You could also use some language to listen on a port and write to SQL server.

Re: Connect ESP32 to MS SQL Server

Posted: Fri Sep 20, 2019 11:00 pm
by Agree007
HTTP from the esp32 to ms sql server running a python program to receive the data from esp32 and write it to your ms sql.

Re: Connect ESP32 to MS SQL Server

Posted: Fri Sep 20, 2019 11:03 pm
by Agree007
Here is example from esp32 to MySQL 😉

https://randomnerdtutorials.com/esp32-e ... mp-server/