Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to build a SQL connection packet?

Status
Not open for further replies.

rssql

Programmer
Jul 22, 2002
87
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top