Monday, December 23, 2013

Issue with Excel - Microsoft Office Excel cannot access the file

Please refer to the below link

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/12/19/error-microsoft-office-excel-cannot-access-the-file-while-accessing-microsoft-office-11-0-object-library-from-ssis.aspx

Solution is as below
SOLUTION:
For Windows 2008 Server x64: Create the following directory:
C:\Windows\SysWOW64\config\systemprofile\Desktop
For Windows 2008 Server x86: Create the following directory:
C:\Windows\System32\config\systemprofile\Desktop

Wednesday, June 26, 2013

Issue with the Web solution - Unable to get the project file from the Web Server


For the "Unable to get the project file from the Web Server" error message, please check the following:

1. Check the webinfo file, make sure the "URLPath" is correct.

2. Recreate the virtual directory for it and restart IIS.

3. Delete the project cache in "C:\Documents and Settings\<username>\VSWebCache"

Additionally I post two related links below, please check them at your convenience.

Unable to get the project file from web server

http://forums.asp.net/t/300746.aspx

Fix for: "Unable to get the project file from the Web server" error

http://askars.wordpress.com/2006/10/28/fix-for-unable-to-get-the-project-file-from-the-web-server-error/
 

Friday, May 31, 2013

To check for a duplicate entry in a column in excel

Take the Column in column A in which the duplicate value needs to be checked.
Use the Below formula in a new column say column B next to the A and insert the formula against it.

The status FALSE means that it is not an duplicate entry

The status TRUE means it is an duplicate entry

Thursday, May 16, 2013

Change the Password for the user in IBM MQ

Below is the command to change the Password for  a user in IBM MQ

The below needs to be given in thecommand prompt

AMQMSRVN -user <domain\>NEW_NAME -password <password>

Tuesday, April 9, 2013

Procedure to disable the triggers


Below is the procedure to disable the triggers

CREATE PROCEDURE [dbo].[DisableAllTriggers]

AS

DECLARE @string VARCHAR(8000)

DECLARE @tableName NVARCHAR(500)

DECLARE cur CURSOR

FOR SELECT name AS tbname FROM sysobjects WHERE id IN(SELECT parent_obj FROM sysobjects WHERE xtype='tr')

OPEN cur

FETCH next FROM cur INTO @tableName

WHILE @@fetch_status = 0

BEGIN

SET @string ='Alter table '+ @tableName + ' Disable trigger all'

EXEC (@string)

FETCH next FROM cur INTO @tableName

END

CLOSE cur

DEALLOCATE cur

GO

----To execute the SP

EXEC [DisableAllTriggers]

 

Thursday, March 14, 2013