Showing posts with label directly. Show all posts
Showing posts with label directly. Show all posts

Wednesday, March 28, 2012

PDF Rendering from an ASP page

Hi Friends,
How can we render a page in pdf format directly from the Web
Aplication. With out the File Down Load screen.
Thanks
Josethis is a browser issue. You can stream the report (in any format) down to
the browser as
contenttype={what ever you got} and
response.writebinary({your array of bytes})
The browser decides to do the open vs. save dialog depending on its own
settings, I think.
dlr
"Jose Francis" <josefrancis@.gmail.com> wrote in message
news:482833ae.0409170516.1ec28fb2@.posting.google.com...
> Hi Friends,
> How can we render a page in pdf format directly from the Web
> Aplication. With out the File Down Load screen.
> Thanks
> Jose

PDF generation without the save/open window

When we generate a report directly to PDF the user is asked to open or save
the PDF before it is displayed.
Is there a way to have the PDF open automatically without that window being
displayed?
Thanks!We are having the exact same problem....did you ever get an answer to this
problem ? Anyone come across this previously '
Thanks
"PJJ" wrote:
> When we generate a report directly to PDF the user is asked to open or save
> the PDF before it is displayed.
> Is there a way to have the PDF open automatically without that window being
> displayed?
> Thanks!|||Scott:
Sadly, we have not received a response. This is a significant drawback for
my users and we would welcome any information about this issue.
PaulJ
"ScottJ" wrote:
> We are having the exact same problem....did you ever get an answer to this
> problem ? Anyone come across this previously '
> Thanks
> "PJJ" wrote:
> > When we generate a report directly to PDF the user is asked to open or save
> > the PDF before it is displayed.
> > Is there a way to have the PDF open automatically without that window being
> > displayed?
> > Thanks!|||This is a limitation of Report Manager. Using our SOAP methods it would be
pretty easy to replace our UI with your own that did not exhibit this
behavior.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"PJJ" <PJJ@.discussions.microsoft.com> wrote in message
news:6C2ECAD1-18C9-478F-B159-7AEB1F175B94@.microsoft.com...
> Scott:
> Sadly, we have not received a response. This is a significant drawback
> for
> my users and we would welcome any information about this issue.
> PaulJ
> "ScottJ" wrote:
>> We are having the exact same problem....did you ever get an answer to
>> this
>> problem ? Anyone come across this previously '
>> Thanks
>> "PJJ" wrote:
>> > When we generate a report directly to PDF the user is asked to open or
>> > save
>> > the PDF before it is displayed.
>> > Is there a way to have the PDF open automatically without that window
>> > being
>> > displayed?
>> > Thanks!

PDF generation

What is implemented in the released version of Reporting Services concidering
generating PDF output directly out of reporting serivces?
The white paper says: â'You are not required to run any Adobe software on the
report server in order to render reports in PDF.â' In the hand book to
Reporting Services of Brian Larson it is written: ""First of all, you will
need some type of utility to produce output in a PDF format. This could be
Adobe's full version of Acrobat or some other utility."I have Reporting Services with service pack 1 on it and it can output
directly to PDF.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> What is implemented in the released version of Reporting Services
concidering
> generating PDF output directly out of reporting serivces?
> The white paper says: "You are not required to run any Adobe software on
the
> report server in order to render reports in PDF." In the hand book to
> Reporting Services of Brian Larson it is written: ""First of all, you will
> need some type of utility to produce output in a PDF format. This could be
> Adobe's full version of Acrobat or some other utility."
>|||Thank you very much for your help, Paul
"Paul" wrote:
> I have Reporting Services with service pack 1 on it and it can output
> directly to PDF.
>
> "pwi" <pwi@.discussions.microsoft.com> wrote in message
> news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> > What is implemented in the released version of Reporting Services
> concidering
> > generating PDF output directly out of reporting serivces?
> > The white paper says: "You are not required to run any Adobe software on
> the
> > report server in order to render reports in PDF." In the hand book to
> > Reporting Services of Brian Larson it is written: ""First of all, you will
> > need some type of utility to produce output in a PDF format. This could be
> > Adobe's full version of Acrobat or some other utility."
> >
>
>

Wednesday, March 7, 2012

password encryption

Hi all Im used to work on mysql and in that Db you can call the password function to encrypt password, so that people browsing directly the db can't see others password.

What is the best way to do this in sqlserver ?

You may use these two undocumented SQL Server functions.

PWDEncrypt and PWDCompare

How to use them?
http://msmvps.com/blogs/gladchenko/archive/2005/04/06/41083.aspx

Pwdencrypt() Weakness
http://www.sqlteam.com/article/pwdencrypt-weakness

Good luck.

|||

so as I see it. It seems easy to hack, So I will ask an other question to you. How do you procede to encrypt password? do you encrypt in code instead of in the db?|||

Frist thing you need to make Password column as VarBinary.

It will save in encrypted format. If you dont wanna use builtin function then make some function which will add some values and then subtract some values.

Hope this will help you.

DBMaster

My Blog

|||

You could use varbinary, you could also use binary, since the results will always be the same lengh.

Public Function MD5(s as string) as byte()

Dim encoder as New UTF8Encoding()
Dim md5Hasher as NewSystem.Security.Cryptography.MD5CryptoServiceProvider

return md5Hasher.ComputeHash(encoder.GetBytes(s))

end function


dim cmd as new SqlCommand("INSERT INTO Users(UserName,Password) VALUES (@.UserName,@.Password)",conn)

with cmd.parameters

.add("@.UserName",sqldbtype.varchar).value=txtUsername.text

.add("@.Password",sqldbtype.varBinary).value=md5(txtPassword.text)

end cmd

...

dim cmd as new SqlCommand("SELECT COUNT(*) FROM Users WHEREUserName=@.UserName ANDPassword=@.Password",conn)

with cmd.parameters

.add("@.UserName",sqldbtype.varchar).value=txtUsername.text

.add("@.Password",sqldbtype.varBinary).value=md5(txtPassword.text)

end cmd

if cmd.executescalar<>1 then

throw new applicationexception("Bad password")

endif