August 3, 2004 at 9:12 pm
One of my client is producing reports on a AS400 system. Currently he is sending a txt file to his remote users. Now he would like to be able storing those raw txt file in a SQL Server database so he could offer some sort of friendly web user interface. Reports can be around 2Mb of text per report. Is there a way to store a text file in SQL Server as it is an retrieve it as it is as well ?
Jean-Luc
www.corobori.com
August 4, 2004 at 7:53 am
In short, Yes it is possible. Your post however does not give enough information for someone to tell you how.
You can store the Text of a text file in a row in the database using the text or ntext datatypes. These have a max length of 2 gig.
Or you can store actual .txt files as a document using a image datatype. This also has a max size of about 2 gig.
I guess we would have to know more to give you any more help
Tal McMahon
August 5, 2004 at 2:50 am
Hmmm, friendly web user interface, ay?
I know this is not an answer to your question, but I can't help it - demonstrate Reporting Services for him! I have just started playing with it, so I am not yet an expert. However, when I demonstrate my relatively simplistic reports to management and colleagues, they almost start salivating...
Leif
August 5, 2004 at 6:30 am
Beware of web services,
Out of the box reading all of the Propoganda they are really cool. But, currently, they are not designed for anonymous public use like...oh say the internet.
I was quite dissappointed to discover that after spending weeks creating reports.
If however your users are nt/authenticated then all is well.
good luck
tal
August 5, 2004 at 6:40 am
I am not going to use it until 2005 is out and stable - I just have a feeling that they will change it just enough to make lots of work on it now invalid - see XML and Analysis services......
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply