Data Base data Insertion Problem (SOS..) [modified]
-
I am having a VC++/MFC application it is receiving 10,000 paramaters per second (4 bytes per paramater) from remote side.I want to insert this data into Oracle server using ODBC .But any database is having maximum fieldsize of 8000 chars or Maximum 1000 field in one table. So how do I insert this type of data into oracle or MS SQL server. I want to retrive this data for further stasstics.Please help Thanks in Advance -- modified at 8:01 Tuesday 30th May, 2006
-
I am having a VC++/MFC application it is receiving 10,000 paramaters per second (4 bytes per paramater) from remote side.I want to insert this data into Oracle server using ODBC .But any database is having maximum fieldsize of 8000 chars or Maximum 1000 field in one table. So how do I insert this type of data into oracle or MS SQL server. I want to retrive this data for further stasstics.Please help Thanks in Advance -- modified at 8:01 Tuesday 30th May, 2006
Assuming that you mean the remote side is sending you 40,000 bytes of data per second, and you want to store that data as a distinct row, then you probably need what's known as a BLOB field (Binary Long OBject). If memory serves, then you can only have one of these per row. Steve S Developer for hire