Monday, October 26, 2009

Error trying to add Web Reference to SmartDevice Project in VS 2008

In a development of SmartDevice project in Visual Studio 2008, when add or update a Web Reference an error message like the following is showed:

The custom tool 'MSDiscoCodeGenerator' failed. Could not retrieve the current project.

To solve this issue, just go to the command prompt in the Visual Studio 2008 directory (Start -> Programs-> Microsoft Visual Studio 2008 -> Visual Studio Tools -> Visual Studio 2008 Command Prompt )

From the command line execute the following command:
  • devenv /resetskippkgs
With that, a new instance of VS 2008 will be started and the update or add of the Web Reference will work fine.

Monday, October 5, 2009

Error in TFS Reports. Query execution failed for data set 'dsLastProcessedTime'

When upgrade to SQL Server 2008, the SQL Server that use the TFS to show the reports present the following message:

Query execution failed for data set 'dsLastProcessedTime'.

To resolve this problem, you need to do the following:

  1. Go to the following Address http://server/Reports
  2. Select the Data Source TfsOlapReportsDS
  3. Check the option 'Enable This Data Source'
  4. In Data Source Type, select 'Microsoft SQL Server Analysis Services'
  5. In Connection String, write 'Data source=[servername]; initial catalog=TfsWarehouse' (without ')
  6. Check 'Credentials stored securely in the report server', and type the user name [domain\user] and the password for the user in the domain who has access to the server of analysis Services.
  7. Check 'Use as Windows Credentials ...' and 'Impersonate the authenticated user...' and click the botton Apply.

After that, do the same for the Data Source TfsReportDS, with the following exceptions

  1. In the Data Source Type, select Microsoft SQL Server.
  2. In the Connection String write 'Data Source=[servername]; initial catalog=TfsWarehouse'.

Use the same configuration used in the Data Source TfsOlapReportDS.

With that, the reports should be showed again.

Saturday, July 25, 2009

Error trying to open a DataBase from SQL CE in Visual Studio 2008

When trying to open or create a database of SQL CE in Visual Studio 2008 , and an error is showed like with the following message:

"An error ocurred while retrieving the information from the database"

To resolve this issue follow the next step:

1. Install the SSCEVSTools-enu.msi from the VS 2008 SP1 folder, if you have that files.

2. If you don't have that folder, install or reinstall the VS 2008 SP1.

With that, this issue is resolved.