problem to connect to microsoft sql2012

Projects Networking, Protocols, and Devices
1

I have a problem to connect to Microsoft SQL 2012

plz any one test it can help me

2

I have a problem to connect arduino uno to Microsoft SQL 2012

3

plz any one test it can help me

I tried. I had no problems.

4

can you send data from arduino to sql

5

can you send data from arduino to sql

Of course not. SQL Server does not listen to the serial port or to the httpd daemon.

You can send data to either IF you have an application that can read the data and talk to SQL Server.

I can write such an application.

6

plz can u send me the way to do it

7

There is too little information in any of your posts to be able to help you.

How is the Arduino connected to the machine that SQL Server is running on? What, EXACTLY, is the Arduino doing?

8

Sorry.
I want to take data from arduino uno to sql server Through
arduino Ethernet Shield to Processed it later

9

I want to take data from arduino uno to sql server Through
arduino Ethernet Shield to Processed it later

So, your Arduino is going to be making GET requests to execute a script on the server. That script is what is going to take the name = value pairs in the GET request, and deal with the SQL Server instance.

10

is that mean the data should be save on arduino first
then server read it?
do you have some example

11

is that mean the data should be save on arduino first

What data?

If you are, for instance, reading temperature from a temperature sensor, you could have the Arduino make a get request like this:

   client.print("GET /saveTemperature.php?temp=");
   client.print(temperature);
   client.println(" HTTP/1.1);

You would then need a PHP script, called saveTemperature.php, on the server that knows how to talk to the SQL Server instance, and knows how to store the data in the appropriate table in the appropriate database using the appropriate credentials.

The process is NO different from having one PC, using a web browser, save data on another computer (a server). Understand that process before you try to replicate it using an Arduino.

12

then need a PHP script, called saveTemperature.php

this script where did save the data and what the extension of it

13

this script where did save the data

knows how to store the data in the appropriate table in the appropriate database using the appropriate credentials.

and what the extension of it

Your kidding, right?