"A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) "
Hi i get thsi exception when io try to load into a DB a file (680MB) ..
when i load into it a file like 200 Mb no problem ...
Btw when i try to load that big file.. it make great HDD work and after 10 min i get that exception
Here is a bit of code.. that loads a file..:
FileInfo inf = new FileInfo(path);
SqlCommand cmd = new SqlCommand("sp_storeFile", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id_info", SqlDbType.Int);
cmd.Parameters["@id_info"].Direction = ParameterDirection.Input;
cmd.Parameters["@id_info"].Value = 1; // just some value
cmd.Parameters.Add("@ext", SqlDbType.Text);
cmd.Parameters["@ext"].Direction = ParameterDirection.Input;
cmd.Parameters["@ext"].Value = inf.Extension; the file extension
cmd.Parameters.Add("@continut", SqlDbType.Text);
cmd.Parameters["@continut"].Direction = ParameterDirection.Input;
cmd.Parameters["@continut"].Value = text; // some text
cmd.Parameters.Add("@descriptie", SqlDbType.Text);
cmd.Parameters["@descriptie"].Direction = ParameterDirection.Input;
cmd.Parameters["@descriptie"].Value = descriptie; // some description of the file
cmd.Parameters.Add("@data", SqlDbType.Image);
cmd.Parameters["@data"].Direction = ParameterDirection.Input;
cmd.Parameters["@data"].Value = File.ReadAllBytes(path); // path is path from the file to load
cmd.ExecuteNonQuery();
Help Guys ....
why am i getting this -- sql
Hot Topic
Visual C#
- How to resize a Nonrectangular form?
- FCKeditor as HTML offline editor in a c# application
- Checking values of variable at runtime.
- #msntb_toolbar_full_name#
- To move from one textbox field to another
- FxCop problem at compile time
- RTC applicaiton is still running after close
- Typing in Visual Studio 2005 Text Editor is extremely slow
- window service unable to launch process
- Encrypt Passwords in the code
why am i getting this -- sql