Transfer Data from Arduino Board to SQL Server

0 votes

Please tell me How to send ultrasonic detection readings from Arduino to SQL Server using Ethernet Cable. Need Code or Helping material or Link. 

PS: I don't want to send it by using any Wifi module to Arduino just by using Ethernet Cable.

Thanks...!!

Aug 29, 2018 in IoT (Internet of Things) by Matt
• 2,260 points
667 views

1 answer to this question.

0 votes

If you want to send it to sql server using the arduino, you have one of two options. (And I think really only one)

For both, you will need to write Arduino code that can talk to an external server.

You can find info on that here

Next, you will need to decide if you want to send it directly to a SQL Server, or if you want to send it to a RESTful Web API, and have that API write the data to SQL Server.

The first option will require you to write your own implementation for TDS over TCP. TDS is the protocol SQL Server uses to send and recieve database queries.

You can find info on SQL Server and the TDS protocol here

This option will be a lot of work, and I am not sure that you will have enough room on the arduino to fit all of the code that would be required for even just a dirty, minimal implementation. Nevermind a reliable, quick, and safe one.

Your other option would be to implement a way to send HTTP Requests over TCP using the arduino. This would allow you to talk to a Web-based REST API. The API would act as a middle man, taking HTTP GET or POST Requests from the arduino, and translating them to SQL Server by means of some database driver.

As far as implementing HTTP with the arduino, you can do that with precreated libaries, like this

As far as what you would use for an API, that can be any Server Side programming language. I personally recomend using ASP.NET to create the API, and ADO.NET to talk to the database. There is lots of documentation all over the net on both of these subjects. A good place to start would be here for a Web API and here for information on ADO.NET

answered Aug 29, 2018 by anonymous2
• 4,260 points
I am getting the issue to transfer data from the Arduino board to SQL Server and getting some errors. What should I do to resolve this issue?

Related Questions In IoT (Internet of Things)

0 votes
1 answer

How to use the data I receive from Azure IoT Hub?

The payload you receive will be a ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by DataKing99
• 8,100 points
74 views
0 votes
1 answer

Send data from cloud to aws iot thing

Your solution is not recommend because there ...READ MORE

answered Aug 2, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
74 views
0 votes
1 answer

How to read data from MQTT in Eclipse Paho?

You don't read data from a MQTT ...READ MORE

answered Aug 9, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
64 views
0 votes
1 answer

Using Google Maps to track GPS enabled Arduino Board

What is the GPS Module which you ...READ MORE

answered Sep 6, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
513 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Suggest Implementation method for Smart Parking Points

They are different things. Raspberry PI is ...READ MORE

answered Aug 24, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
22 views
0 votes
1 answer

How to send a data from arduino uno to a webpage through esp8266 wifi module?

You are missing a few \r\n and the length ...READ MORE

answered Aug 9, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
1,251 views
0 votes
1 answer

Azure - What service to use for Arduino data (iot)

That's because the two services do completely ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
77 views