Way to Expose Custom method in an Entity class from WCF Data Service

There are scenarios where we may want to add additional methods to an Entity class. When we implement  them we have to extend the Entity Data Model Class project by implementing a partial class in our Entity Project. We then create a data service and reference the EDM class project . You can add custom…

0

How to create a linked server in SQL Server 2005 for Sybase ASE 12.5 database using DataDirect’s ODBC Driver and OLEDB provider?

Linked server in SQL Server 2005 to Sybase ASE 12.5 can be created with both ODBC driver and OLEDB provider.  Below are the steps. A. Creating Linked server for Sybase ASE 12.5 from SQL Server using DataDirect Sybase Wire Protocol ODBC driver Install the DataDirect ODBC Driver for Sybase on the machine running SQL Server….

4

MSDB and File System doesn’t appear under Stored Packages, After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio

Cause and Resolution SSIS uses the value of Registry key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile” to locate the location of SSIS configuration file on the machine.  If this key doesn’t exist or doesn’t point to the correct path of the file MsDtsSrvr.ini.xml, this issue may occur.  The default path of this file is “%ProgramFiles%\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml”. When the SSIS…

3

SSIS error “Failed to retrieve data for this request”: reasons and resolutions

  1.  After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio, when you expand MSDB under Stored Packages to see list of stored packages, you may get below error. Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: The SQL server specified in SSIS service…

3