Saving images in SQL server does not work on production/test server - dows work on dev

Last post 02-24-2011, 11:48 AM by erave02. 2 replies.
Sort Posts: Previous Next
  •  02-23-2011, 7:16 AM 66391

    Saving images in SQL server does not work on production/test server - dows work on dev

    Hi,
     
    I'm trying to test the SQL image storing functionality.
    It works fine on my local machine, using the local SQL server.
    However, on the test and production server it can read the information from the SQL server, but cannot create new directory or file.
    I tried to debug on the test server - 
    put a breakpoint on  CreateDirectory(..)
    Run the application - click insert image
    I can see the folders I manually created on the DB (for testing)
    I click "create directory" enter the directory name, and click OK - now it just hangs... 
    It doesn't even stop at the break point! 
     
    Any idea?
    (both dev and test use VS2010 and SQL 2008)
     
    Thanks,
    ER
    Filed under:
  •  02-23-2011, 8:59 PM 66405 in reply to 66391

    Re: Saving images in SQL server does not work on production/test server - dows work on dev

    Hi erave02,
     
    Can you send the test page url to [email protected]. I will check it and get back to you as soon as possible.
     
    Regards,
     
    Ken
  •  02-24-2011, 11:48 AM 66432 in reply to 66405

    Re: Saving images in SQL server does not work on production/test server - dows work on dev

    I found out was was the problem.
    I realized the problem was in the kernel of the http, because the POST did not even get to the IIS.
    I allowed logging for http.sys (http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/51d3f209-769f-4a77-aba1-52f2e052209c.mspx?mfr=true)
    and saw the the error was because of timeout.

    I then looked into it more and more, and saw that the firewall was preventing the call because it figures the length of the URL as malicious.
    I tested it when I disabled the URL checking on the FireWall, and it worked fine.
    However, I cannot keep the firewall open (obviously) so I was hoping you have something that can be done to help on this issue.

    Thank you very much,
    ER
View as RSS news feed in XML