Connect ESP32 to MS SQL Server

tomcat2900
Posts: 8
Joined: Tue Jun 25, 2019 11:24 pm

Connect ESP32 to MS SQL Server

Postby tomcat2900 » Fri Sep 20, 2019 9:21 pm

Hello!

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

Thank You !

tommeyers
Posts: 184
Joined: Tue Apr 17, 2018 1:51 pm
Location: Santiago, Dominican Republic

Re: Connect ESP32 to MS SQL Server

Postby tommeyers » Fri Sep 20, 2019 9:40 pm

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.
IT Professional, Maker
Santiago, Dominican Republic

tommeyers
Posts: 184
Joined: Tue Apr 17, 2018 1:51 pm
Location: Santiago, Dominican Republic

Re: Connect ESP32 to MS SQL Server

Postby tommeyers » Fri Sep 20, 2019 9:50 pm

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.
IT Professional, Maker
Santiago, Dominican Republic

Agree007
Posts: 103
Joined: Mon Sep 18, 2017 7:11 pm
Location: Copenhagen

Re: Connect ESP32 to MS SQL Server

Postby Agree007 » Fri Sep 20, 2019 11:00 pm

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.

Agree007
Posts: 103
Joined: Mon Sep 18, 2017 7:11 pm
Location: Copenhagen

Re: Connect ESP32 to MS SQL Server

Postby Agree007 » Fri Sep 20, 2019 11:03 pm

Here is example from esp32 to MySQL 😉

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

Who is online

Users browsing this forum: Google [Bot] and 154 guests