Saving Ntext Data From SQL Server To File Directory?
Mar 15, 2010
A variety of files (pdf, images, etc.) are stored in a ntext field on a MS SQL Server. I am not sure what type is in this field, other than it shows question marks and undefined characters, I am assuming they are binary type.
The script is supposed to iterate through the rows and extract and save these files to a temp directory. "filename" and "contenttype" are given, and "data" is whatever is in the ntext field.
[code].....
This works, but the file should be saving to the server instead of popping up save-as dialog. I am not sure if there is a way to save the response to file.
So I have a ntext column in a table with a combination of large random data (hence why ntext in the first place) and sometimes contains a uniqueidentifier.
I need to find and delete rows based on the uniqueidentifier.
I can't do the comparison with it being ntext, but I changed it to varchar(max) in my dev enviornment and it let me do it without any warnings and I can now do my comparison like I want to, so all is good.
I just want to make sure I'm not changing any of my large random data by changing the data type.
I have a bit of code in a clickevent handler like this:-
Dim products = From p In db.Products where p.product_name = "Tool" Select New With {p.Product_ID,p.Product_name} Gridview1.Datasource = products GridView1.Databind()
But causes error=SQL Server does not handle comparison of NText, Text, Xml, or Image data types?
I am just learning application development and my question is so I can demo a project from an Internship for a class at school. I am planning on using Visual Studio 2010 in debug mode for the presentation.
Here it goes:
I created a database utilizing SQL server 2005. I want to take the .mdf file from SQL Server and place it in the App data directory of my application. I am hoping that I do not need to rebuild any datasets that I am currently utilizing. I am utilizing several stored procedures that are in the database, these stored procedure are access utilizing my datasets.
I was able to place the file in the application but I get an exception whenever I try to utilize a stored procedure that was created in the database.
Here is the error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I verified all of my datasets utilize the following connection:
i have the below query where MessageText column is of ntext datatype..whe n i run the below query it is giving me the below error. Error :The data types ntext and varchar are incompatible in the add operator.
select li.LookUpPageInfoId, li.PageMessageID, li.PathMessageID, li.IsActive, m.MessageID, (select messagetext from messages where messageid=pagemessageid and channelid=m.ChannelID)+'/'+ m.MessageText as TotalText, m.ChannelID from LookUpPageInfo as li left outer join Messages as m on m.MessageID=li.PathMessageID and li.IsActive=1
Can some one suggest me how to concatenate the ntext column....but the above works good if the column MessageText is of nvarchar(max) datatype.
Now i want to get the list of message IDs where the message Text Contains some Special characters as like the characters from the below image. how to query to get the list of message ids where the message text contains any one of this special characters.
I have a table with a varbinary(MAX) column. I want to use the FileUpload control to save the file directly there by a stored procedure. How do you do it without using SaveAs to create a temporary file first?
i need to save multiple documents stored in SQL server as Image type to disk.
What i want to do is "backup" all files in a table (column) to disk, zip them and Response.TransmitFile(FilePath) to client.
I could use C# ot VB but that would require a lot of connections to database or a lot of server memory and i don't want that, becauze there are a lot of files to be saved Since SQL can write files to disk i was thinking about saving those files to disk directly from sql. Something like when u're doing a backup
I'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded. I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server (using Linq and VB by the way)
I'm currently writing a website in ASP.NET MVC, and my database (which doesn't have any data in it yet, it only has the correct tables) uses SQL Server 2008, which I have installed on my development machine. I connect to the database out of my application by using the Server Explorer, followed by LINQ to SQL mapping.
Once I finish developing the site, I will move it over to my hosting service, which is a virtual hosting plan. I'm concerned about whether using the SQL Server setup that is currently working on my development machine will be hard to do on the production server, as I'll have to import all the database tables through the hosting control panel. I've noticed that it is possible to create a SQL Server database from inside Visual Studio. It is then stored in the App_Data directory.
Does it make sense to move my SQL Server DB out of SQL Server and into the App_Data directory as an .mdf file? If so, how can I move it? I believe this is called the Detach command, is it not? Are there any performance/security issues that can occur with a .mdf file like this? Would my intended setup work OK with a typical virtual hosting plan? I'm hoping that the .mdf database won't count against the limited number of SQL Server databases that can be created with my plan.
I have a web server with a web application and a website both on it (2 seperate entities within IIS7.0). The web application needs to be able to upload files to a virtual directory created within the same web server and the website needs to be able to view that virtual directory to be able to allow for downloading of those files.
This sounds really easy, but I cannot figure out how to do the upload and the download.
Example:
Virtual directory = own folder file structure (does not fall within either website/webapp structure)
Website - standard user for outside users.
Webapp - authentication requierd and only used by inside users.
Webapp users upload files to virtual directory Website users download files from virtual directory (i.e. open files)
I have an ASP.NET application running on Apache server with mod_mono. If I have a folder called "temp" located in the website's root directory and run the following code
System.IO.TextWriter tw = new System.IO.StreamWriter("temp/test.txt"); tw.WriteLine(DateTime.Now); tw.Close();
it saves test.txt in C:Program FilesMono-2.6.4in emp on the server. If I add a slash to the directory name like this: System.IO.TextWriter tw = new System.IO.StreamWriter("/temp/test.txt"); It saves it to C:/temp. Both do not do what I want. How do I get the code to save the file to the temp folder inside my website's root directory? Is this a mod_mono issue or something to do with Apache? I have tried adding this line to httpd.conf Alias /temp "C:/Path_to_root_folder/temp" without any luck. I shouldn't have to use alias if the temp folder is within the root directory, correct? In my development environment which uses XSP as the web server everything works as expected. It is only a problem when running on Apache.
I have an ASP.Net (2.0) application on an intranet that impersonates the users Windows login.
It has <identity impersonate="true" /> in the web.config file.
In a couple of places it needs to create a file in the temp folder of the server (a text file in one instance and a Word doc in another instance) before sending the resulting file to the user, after which it is deleted.
It runs into a permission problem, which I assume is because the user that is being impersonated does not have permission to write to the server's hard drive.
How do I overcome this?
I assume it be something along the lines of temporarily running under a different account for the create/read/write/delete temp file parts of code.
how to do this and which account would be the best (easiest) to use. It will be a Windows 2003 server.
I am trying to code (.net) in the autosave functionality without clogging the network. I am trying to capture data from a webpage into a file on the local drive and automate save every 5 mins. Then finally when the user hits "save" the data should be pulled from the local file to update the data base.
i have done a small code like if i enter some value in my text box i will pop up a new form corresponding to the value entered i will take the values from the pop up form and click on save and i am redirecting to the previous page and will click on save now i would like to save the data along with the data that is entered in the pop up form
Ex : My first form is like
Name ABC
Address XYZ
Value 3 Here when i enter 3 i will get a pop up if i click on save it will take input 3 times from the user. That data should be carried to the prev form and wiil fill the remaining values in that form and click on save
I am trying to explode some data from an ntext field into a cvs for import, here is what i have so far,
DECLARE @XML as XML DECLARE @hDoc as INT SET @XML = (SELECT billaddress FROM order WHERE id=7 ) exec sp_xml_prepairedocument @hDoc OUTPUT, @XML SELECT firstname FROM OPENXML (@hDoc, '//') WITH (type text './type/@text', FirstName text './FirstName/@text') exec sp_xml_removedocument @hDoc OUTPUT
here is the errors:
Msg 2812, Level 16, State 62, Line 4
Could not find stored procedure 'sp_xml_prepairedocument'.
Msg 8179, Level 16, State 5, Line 6
Could not find prepared statement with handle 0.
Msg 6607, Level 16, State 3, Procedure sp_xml_removedocument, Line 1
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
Using the Interop for Excel 2003 I had a nice little link that saved or opened the repeater content as .xls. Now we are using Excel 2007 and I get file format error messages. When I click the OK button on the error pop-up Excel closes. Does anyone out there know how to convert my code to handle the .xlsx format? I've been reading up on Interop for 2007 but none of the examples seem to work for this particular simple task. Here is my code from the "Export to Excel" button click:
Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click ' Send HTTP headers that specify Excel filename, MIME type, and character set Dim sTemp As String = "attachment;filename=CoverageCase" & Session("OpenCase").casekey.ToString & ".xlsx" Response.AddHeader("content-disposition", sTemp) Response.ContentType = "application/vnd.ms-excel" Response.Charset = "" ' Create objects used to render the controls Dim strw As New System.IO.StringWriter........
I found a thread from a couple of years ago dealing with this but there was no solution [URL]. There were a couple of tortureous work arounds but neither work for me.
I've found a lot of similar topics but none of them solves my problem.
I have table structure like that
[Code]....
Everyone suggests to change ntext type to nvarchar(MAX) and life will be beautyfull. But... First, I need ntext, simply because there should be text in this field.
nvarchar(MAX) equals 4096 bytes which is to small for large text. Second, I already have table with ntext field, which does not cause this error.
Im passing sensitive details from my asp.net web app to a database on a different server. I've set up encryption on my database. Should I encrypt the data in the code behind file of the web app and then pass it to my database stored procedure or pass it to the stored procedure as it is and encrypt it there?
