I have a blob column in mysql database and i am inserting different kind of files like .pdf, .jpeg etc in to that database column.While retrieving that blob data, i want to know what kind of file data i am retrieving(whether it is jpg or pdf) so that i can save that in the known format.
View 4 Replies
I would like to know which is better? Storing images in BLOB or in the File System ? I've got around 400 to 5000 images.
And at run time there are chances where I'll need to retirieve about 100 - 150 images.
I want to import csv file(already uploaded in blob storage) in Azure. For example I have uploded test.csv on blob storage, now i just want to import that test.csv file in .net(azure) and after importing i will insert that data into azure database. I am using C# .net.
Creating a cvs file with all rows. Upload it as blob. Parse it with a Worker role and insert it in the sql azure db.
Is it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
I am using C#. I am consuming a webservice. The webservice has a method, which has the return type as blob. The webservice serializes the data before sending as blob.I am able to access the webservice method, but I am not sure how to store the value, as the return type is a blob.I have tried this:
Service1.TestService serv = new Service1.TestService();
? = serv.Custom_methodname(true);
How to assign the output as it is a blob variable?
Currently we are saving files (PDF, DOC) into the database as BLOB fields. I would like to be able to retrieve the raw text of the file to be able to manipulate it for hit-highlighting and other functions.Does anyone know of a simple way to either parse out the files and save the raw text on save, either via SQL or .net code. I have found that Adobe has a filtdump utility that will convert the PDF to text. Filtdump seems to be a command line tool, and i don't see a way to use a file stream. And what would the extractor be for Office documents and other file types?-or-Is there a way to pull out the raw text from the SQL Full text index, without using 3rd party filters?Note i am trying to build a .net & MSSql solution without having to use a third party tool such as Lucene
View 5 RepliesI am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI'm trying to display images in a GridView (yes, still this...). [edit] Before I can come to that I have to upload some images to the database.
I've followed this tutorial for the "upload image to database" code (this worked fine for uploading images, but I don't know if the images were converted to byte):
[URL]
and I've followed this tutorial for the "display images in gridview" code (and "retrieve file" from the tutorial below).
[URL]
It doesn't quite work, the GridView shows but without images
Now I'm trying to change the "save file" code according to this tutorial:
[URL]
but I don't understand everything in it. When I try to upload an image I get an error on this line:
[Code]....
My admin set innodb_buffer_pool_size=512M, innodb_log_file_size=128M, and innodb_log_buffer_size=1M although in mysql query show global variables its showing what the value is set. When i restart my system also its showing what we set the data.(It means we set log file buffer file size to max and its working fine.) but when i try to upload a file of 58 mb again its throwing error as The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size.
View 1 RepliesI am pulling word documents that have been stored in our db as blobs and presenting them to the user. As you can see below, I am writing to the http stream via BinaryWrite. This is causing the Microsoft Word application to open in a separate window. My goal was to open the word document inside of the browser instead. Preferably inside of an iframe within the browser. Is there a way to target an iframe by some analog of the method below?
[Code]....
I have a problem that i'm sure will not be hard to fix for anyone who has been using CR for some time.
To start I have created a program in VB2008, that uses a MS Access data file, I can connect to it with no problem and can also add data and amend data, so all seems to work perfectly. I have published it and it once again runs perfectly on another/s machines.
I have now a requirement for a number of reports so have choosen CR for this purpose. I have connected the report to the database and that runs with no problems at all, that is untill I try to run it on another machine, it seems not to be able to find the database and comes up with a panel wanting me to log in with a password and Admin name.
I feel it's proberly a problem with the path of the database, I have tried so many time with diferent data files but with no success.
Could not find installable ISAM.
I get the above error when populating dropdown using CSV file ...
Whats the cAUSE of error without making any changes in registry ...
I am currently developing a web application that receives data from an on-site database. The database developers have developed some web-services that I am able to call and send/receive data to and from the the database.
When I want to display an image the method returns the image in BLOB format. My question is: what is the best way to convert BLOB to .jpg or .bmp so I can display the image correctly?
I have an application where a Word document is filled out and saved as a blob.
I want to display that document over the web but I do not want it to open in Word where anyone can edit the fields.
I was hoping to convert the word blob to a pdf on the fly.
I recently installed developer express and sql server 2008 express. I am trying to connect to the sql database but get this error. When I try to add a reference to system.data.sql, it doesn't exist. Did install sql server 2008 service pack 1 wrong or visual studio express service pack 1 wrong?
View 1 RepliesWe are storing images in a DB2 database and would like to display them on the web page.
View 2 Repliesi need to download a file directly from a table's BLOB column .
i used this procedure, but i got the error:
SQL> exec download_blob;
begin download_blob; end;
ORA-06550: line 2, column 7:
PLS-00905: object IFRSCD.DOWNLOAD_BLOB is invalid
ORA-06550: line 2, column 7:
PL/SQL: Statement ignored
The code is:
[Code]....
the location in this if statement is where? I mean what can be the location where can I find the location of this file?
if (File.Exists(Server.MapPath("~/Elina/" + url + ".ascx")))
{
ElinaUserControl elinaPage = LoadControl("~/Elina/" + url + ".ascx") as ElinaUserControl;
MasterPageFile = elinaPage.MasterPage;
m = this.Master;
while (m.Master != null)
{
m = m.Master;
}
if (m.FindControl("Form1") != null && WebConstants.IsChangeFormAction)
((SmartForm)m.FindControl("Form1")).Action = UrlHelper.ElinaURL() + url;
page = elinaPage;
}
else
{
throw new HttpException(404, Request.Path);
}
}
I had a mp3 file, i need to get all its properties such as bitrate of the file, duration of the file from c# code.
View 1 RepliesI have built an ASP.NET (.NET v4) application in VS 2010. It is working just fine. But when I try to create deployment package (so I can deploy it in our test IIS 7.5 Server), it gives me error like this,
Error 1 Could not open Source file: Could not find file 'C:11-2 estobjDebugCSAutoParameterize ransformedWeb.config'. 0 0 test
Thing is in past, I had deployed the SAME application using the SAME method.
my goal is to save an jpeg image in a blob field in oracle. give me code in order to do this.
View 5 Repliesdatabase type field BLOB in oracle but if i use MS SQL and field type as image then this below line code work fine.
here trying to save image in oracle database but system giving me below line error
unimplemented or unreasonable conversion requested
here is my code
[Code]....
Is it possible to find out user successfully downloaded file or not?
View 6 RepliesAt the time of executing below code it gives exception as file not specified for the line p.start(). The target directory and file name is correct.
Process p = new Process();
string targetDir = string.Format(@"C:UsersAdminDesktopRahulLatest ETLETL Working Copy 20101810ETL Working Copy 20101810SchedulerScript Input") ;
p.StartInfo.WorkingDirectory = targetDir;
p.StartInfo.FileName = "ShellScript_" + shedule.CC_ETL_SCHEDULE_ID + ".bat";
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.RedirectStandardError = true;
p.Start();
string res=p.StandardOutput.ReadLine();
string output = p.StandardOutput.ReadToEnd();
[code]...
How do I tell an ASP.NET Web application to look in the current directory for a .pkl file? This file is read in an embedded Python script.So far, I get a FileNotFound exception stating:
[Could not find file 'C:Program Files (x86)Common FilesMicrosoft SharedDevServer10.0 2.pkl'.]
