I have a programmable device on Ethernet, and would like to understand how to connect to some type of database like SQL Svr, or at least to a host computer and have it write my data to a txt file.
My feeble mind thinks that i would build a string, and then send it to the IP/Port. My device would have the IP and port setup in it's message instruction so it knows where to send it.
Would i build my first packet something like this?
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"
How about then sending my data after the connection is made?
Or does the server/host need to be ready to accept my data and save it as a file, or parse it to the database?
I am not using a PC.
-------------------
The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.
Daniel Boorstin
My feeble mind thinks that i would build a string, and then send it to the IP/Port. My device would have the IP and port setup in it's message instruction so it knows where to send it.
Would i build my first packet something like this?
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"
How about then sending my data after the connection is made?
Or does the server/host need to be ready to accept my data and save it as a file, or parse it to the database?
I am not using a PC.
-------------------
The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.
Daniel Boorstin