Wednesday, March 17, 2010

Displaying powerpoint files on a website

I had trouble displaying powerpoint files on the website that I was working on. The problem was the link to the powerpoint file was a powerpoint 2007 show file (.ppsx). But when you clikc on the hyperlink, it was downloading with a .ppt extension

I have done some googling to resolve this problem and found that in order for links to PPTX/PPSX files to work, the two conditions must be met:
  • The user must have PowerPoint 2007, the 2007 Viewer or an older version of PowerPoint with the compatibility pack installed so that they can open PPTX/PPSX files in the first place
  • The web server configuration on your site must have the correct mediatype/MIME settings to serve PPTX/PPSX files as PowerPoint 2007 presentations.

The above is an extract from the article on pptfaq called Control how the browser opens powerpoint files

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...