Michael Bentfeld
asked on
Why is my ASP.NET site not logging PDFs it generates in SQL DB or sending emails?
Hello,
I have a site created in ASP.NET used to generate sales quotes. I am trying to migrate it from a Windows 2003 server with IIS 6.0 to a Windows 2008 server with IIS 7.5. The existing version connects to a SQL 2005 database, housed on the same server as the site (the new server has SQL 2008). When authorized users connect to the site (via AuthentiX), they are asked to select an item to quote from a list and add it to the quote. A popup appears to select options (the user just enters a quantity next to each option desired), which they are then asked to add to the quote. The next page allows them to add taxes, fees, and shipping or other miscellaneous charges. The users are then prompted to enter the sales person's name, email, and mailing address, plus the same information for the customer. The final page allows the user to review the quote, then submit it or go back and change it. When the user submits the quote, five things happen:
As of now, the progress bar disappears and I end up back at the quote review screen. In addition, the emails are never sent (the sales rep and I don't see them because I've used my personal and work emails in testing). Finally, clicking on the "View PDF" button initially resulted in a HTTP 403 error. I could also click on a "Quote History" button to review that user's past quotes (where they can view, edit, or delete their quotes), and that View PDF button also doesn't work for new quotes. However, I can view PDFs of past quotes. When I looked at the database through MS Access, I found the field where the file name of the PDF is supposed to be is blank on the new test quotes. I know the PDF exists because I can go the the file folder where the PDFs are stored and see it. Email should be working because I have and SMTP virtual server set up in IIS and it is authorized to connect to our Exchange server. After researching the matter of the PDFs, I suspected a permissions issue. One solution suggested enabling Directory Browsing, which I did. I can now view the PDFs for my test quotes, but only because I am now presented with the list of all of the quotes ever generated on the site (not the desired solution).
So the question is, how can I get the emails the send (I suspect I'm still missing a permission setting somewhere), as well as get the PDF information into the SQL database? I am attaching the portion of the site code where the PDF is generated and stored, and the confirmation page is displayed.
Code-for-PDF-generation-and-emails.docx
I have a site created in ASP.NET used to generate sales quotes. I am trying to migrate it from a Windows 2003 server with IIS 6.0 to a Windows 2008 server with IIS 7.5. The existing version connects to a SQL 2005 database, housed on the same server as the site (the new server has SQL 2008). When authorized users connect to the site (via AuthentiX), they are asked to select an item to quote from a list and add it to the quote. A popup appears to select options (the user just enters a quantity next to each option desired), which they are then asked to add to the quote. The next page allows them to add taxes, fees, and shipping or other miscellaneous charges. The users are then prompted to enter the sales person's name, email, and mailing address, plus the same information for the customer. The final page allows the user to review the quote, then submit it or go back and change it. When the user submits the quote, five things happen:
A scrolling progress bar appears.
The quote information is entered into one of three tables the SQL database (for general information, what item was quoted, and what options). There is a separate SQL user for the quote site which is set as the DB owner.
A PDF file for the quote is generated and stored on the server, and the name of the file is stored in the 1st SQL table mentioned above (quotes).
Emails are generated and sent to the salesman and customer whose email addresses were entered in the quote, plus our inside sales rep (their email address is stored in the site code).
The progress bar is replaced by a confirmation screen, whereby the user can view the PDF file or go back to the initial quote screen.
As of now, the progress bar disappears and I end up back at the quote review screen. In addition, the emails are never sent (the sales rep and I don't see them because I've used my personal and work emails in testing). Finally, clicking on the "View PDF" button initially resulted in a HTTP 403 error. I could also click on a "Quote History" button to review that user's past quotes (where they can view, edit, or delete their quotes), and that View PDF button also doesn't work for new quotes. However, I can view PDFs of past quotes. When I looked at the database through MS Access, I found the field where the file name of the PDF is supposed to be is blank on the new test quotes. I know the PDF exists because I can go the the file folder where the PDFs are stored and see it. Email should be working because I have and SMTP virtual server set up in IIS and it is authorized to connect to our Exchange server. After researching the matter of the PDFs, I suspected a permissions issue. One solution suggested enabling Directory Browsing, which I did. I can now view the PDFs for my test quotes, but only because I am now presented with the list of all of the quotes ever generated on the site (not the desired solution).
So the question is, how can I get the emails the send (I suspect I'm still missing a permission setting somewhere), as well as get the PDF information into the SQL database? I am attaching the portion of the site code where the PDF is generated and stored, and the confirmation page is displayed.
Code-for-PDF-generation-and-emails.docx
ASKER
I was wondering if you could elaborate on this a little more. Pardon my ignorance, but I have very limited knowledge (almost none) in programming or working with asp or visual basic. I did not originally create this site, and I am unable to contact the person who did. If you think it would help, I can provide more of the code. Thanks again for your help.
Sure.
Add
Dim strSendMailRet, strSQLRet as String
then change the beginning of the code of general.sendMail( and cmd.ExecuteNonQuery()
to
strSendMailRet = general.sendMail(......
strSQLRet = cmd.ExecuteNonQuery()
At the end add
Lfinalmsg.Text = Lfinalmsg.Text & "<br/> SendMailRet: " & strSendMailRet
Lfinalmsg.Text = Lfinalmsg.Text & "<br/> SQLRet : " & strSQLRet
They may return a something.. a 0 is usually Ok.
Add
Dim strSendMailRet, strSQLRet as String
then change the beginning of the code of general.sendMail( and cmd.ExecuteNonQuery()
to
strSendMailRet = general.sendMail(......
strSQLRet = cmd.ExecuteNonQuery()
At the end add
Lfinalmsg.Text = Lfinalmsg.Text & "<br/> SendMailRet: " & strSendMailRet
Lfinalmsg.Text = Lfinalmsg.Text & "<br/> SQLRet : " & strSQLRet
They may return a something.. a 0 is usually Ok.
ASKER
Just tried your suggestions, but I didn't get anything back unfortunately. I checked the database again (I have it connected to an Access 2007 front end on the server), and the quote was generated. My prior research indicated that there could be permission issue somewhere, but I haven't been able to find anything. The only other thing I can think of on that line of thought is I did a new restore of the SQL database last month of a new backup from the original server to keep the quote numbers in sync (the original restore was done some time before), and maybe those permissions got messed up in the process.
Unfortunately, I've got a mini vacation coming up with the family, so I may be delayed in responding for a couple of days (sorry about that).
Unfortunately, I've got a mini vacation coming up with the family, so I may be delayed in responding for a couple of days (sorry about that).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That may be the problem. I tried to check the permissions for the user for db (there's a dedicated user named quote), but got nothing, though I suspect my query syntax was incorrect. However, when i checked in SQL Server Management Studio under the Logins, I found that user doesn't have User Mapping set to that database (though it is set to their default database). They are also the database owner, so wouldn't it stand to reason they should have full permissions? I did try looking at the database properties, and noticed that only the Update permission wasn't checked under any option, so I checked that. I will try over the weekend and advise. Thanks again.
It looks like your SQL statement is correct.
As a side note, you may want to into parameterizing your sql statement to prevent sql injection.