Creating PDF (or any other file type) from SQL Reporting Services using .WSDL (VS2012) Part 2

Last Updated on Tuesday, 11 December 2012 08:53 Written by David Bauernschmidt Tuesday, 11 December 2012 12:00

If you have been following along in Part 1 you know that by now you will have a web service ready to be consumed in your project. Let’s continue on with this example and create a report that is hosted at Arvixe. (Concepts apply to most vendors). One thing to keep in mind with Arvixe this that testing your code report link is different than when you deploy it. I will get to that in a minute but let’s continue on.

Right click on your project and select ..”Add New Item” (figure 1)

Figure 1

Select Generic Handler and name the file something like ….”SSRS.ashx

How to See MySQL Query Errors in PHP

Last Updated on Tuesday, 20 November 2012 12:45 Written by Richi González Thursday, 22 November 2012 12:00

Hello,

Some people create queries that do not work and don’t have a clue why they don’t, as no error is displayed. I’ll show you how to display the MySQL error, if any, when the query is run. A must know for programmers. Great tool for debugging queries.

1. Open the file where you have your query. For this article, I will be using the following code:

Changing Collation for SQL Server 2008 R2 Express

Last Updated on Saturday, 2 July 2011 02:38 Written by Ian McIntosh Friday, 1 July 2011 12:00

This article builds on the previous post and is part of a series to setup local and remote working environments for MojoPortal.

Background

If you have differing collations on your local and remote databases, you are likely at some stage to see collation errors.

Checking Collation of Your MojoPortal Databases

Last Updated on Thursday, 30 June 2011 01:18 Written by Ian McIntosh Thursday, 30 June 2011 12:00

This article builds on the previous post in the series about how to setup local and remote working environments for MojoPortal.

Background

Collation settings in SQL Server affects character set, sort order and case sensitivity.

Creating a Remote MojoPortal SQL Database

Last Updated on Thursday, 30 June 2011 01:18 Written by Ian McIntosh Wednesday, 29 June 2011 12:00

This article builds on the previous post in this series, providing a step-by-step guide to setting up local and remote environments for MojoPortal.

In this post, I will walk you through creating a remote database, by which I mean creating a new MS SQL database on your hosting account.

This is a pretty straight forward task, but there are a couple of things to watch out for. For this reason, I give it a post of its own.