Hex value feed to sql table

[omprakash]

Hex values to be entered to sql table interms of bytes

i.e in first column 2bytes of hex value.

 in second column 4bytes of hex value

  in third column 2bytes of hex value

any brave ideas appreciated...

[smercurio_fc]

What is your specific question? What to use to interface to SQL Server? If so, you would need to use either the Database Toolkit from NI, or use the free LabSQL. If you already have these, then are you asking how to use them? Have you looked at the examples?

Aside: what is the datatype of your columns in the SQL Server table?

[omprakash]

Nice analysis  smercurio_fc.

Im using free LabSQL.Its pretty good too.Here i was able to establish communication between server and my code was dumped in to server.

Problem is im having huge data to sent and data is in Hex format.Data format sent is like

        1st 16byte char.

then 8byte long

then 4 byte enum

then 4 byte long         goes on etc

Now as the data is in hex format im unable to understand it.

Any how no need of understanding too.

MY NEED IS TO SEND DATA to server as per the Data format.so im planning to 1st put the data in to table and then send it to server.

So any help please...

[smercurio_fc]

That's all well and good, but you have still not provided any information on the database schema. What is the structure of the table the information is going into? Also, what do you mean the data is in "Hex format"? Can you provide some code?

[omprakash]

thanks for your reply,

code i cant provide.I have some rules to follow.

im storing some huge data in hex format in my microcontroller.

Through serial communication Im getting data to my computer and storing it in a FILE .

problem here is data read in the form of ASCII.

what im trying is to convert this ascii to hex and then seperatise sring,double,float,int and store it in a table.

any help...