Need help in insert a huge file as a blob into SQL Server DB

Hi,

I have a huge file that is a matrix. The size of the matrix change daily, but always around 100MG.

I need to insert it into a Sql Server database as a blob. How to do that?

I read the data insert from this site but still need help here, since it is different from all other inserts.

Thanks a lot.

Jennifer

[Rebecca Krosnick]

What commands are you currently trying to use? Do you experience any errors?

You should use the "fread" function to read the binary data from the MAT file. You can then insert the binary data as a BLOB object into the database using the an insert function.

Note that the Native ODBC interface does not support the BLOB datatype, but the JDBC driver does.