Internet Browser problem

June 19, 2008 – 4:36 pm
Windows XP SP2, Internet Explorer 7 I got call from user: Every time when I close the browser, it takes a long time for it to go away, followed by an error message. I would live with it, but I am afraid that it might affect survey testing. Could you find a fix? event viewer error was: Faulting application iexplore.exe, version 7.0.6000.16640, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Resolution: In IE > Tools > Internet Options > Advanced > Reset

Posted in IE7, Windows | No Comments »

Cannot connect to VPN

June 19, 2008 – 4:29 pm
Windows XP SP2, Symantec AV (enterprise), Cisco VPN client 4.6 I got call from user: I cannot connect to the VPN. When I try to connect, I receive the following message... Error 51: IPC failed with error -4h. This is most likely due to the Cisco System Inc. VPN Service not being started. Please start this service and try again. Resolution: Found that it is conflict issue between AV and VPN client. If "Enable File System Real Time Protection" was unchecked (disabled), user had no problems launching VPN client. Uninstalled AV. Uninstalled VPN. Reinstalled AV. Reinstalled VPN. Also did the following on the computer. sfc /scannow chkdsk /f defrag C: /a regestry cleaning

Posted in Cisco, VPN | No Comments »

One or more activex controls could not be displayed in Outlook

March 28, 2008 – 10:32 pm
Windows XP SP, Outlook 2003  User was getting error message "One or more activex controls could not be displayed...". It is 2 ways to resolve this issue. 1) Check checkbox for "Use Microsoft Office Word 2003 to edit messages" in Outlook's Tool >> Options >> Mail Format 2)If you don't want to use Word. Go to  C:\Documents and Settings\user_name\Application Data\Microsoft\Signatures Make sure you make a copy of the *.htm signature. Open htm signature in notepad. Search for tag <object>. Delete everything between <object></object> tags, including tags. Save document. The problem is solved.

Posted in Outlook, Windows | No Comments »

System error. Your computer was affected by unknown trojan

March 27, 2008 – 6:27 pm
OS Windows XP SP2. Got call from user who was getting "system error your computer was affected by unknown trojan" error every time he would open IE browser or Windows Explorer. User had Symantec AV running also Windows Defender. I also had to install SpyBot and Adaware and run it. I did scan for viruses and spyware.Everything seems to be OK, but this error would not go away. Solution that worked for me was removing registry entry. Please, make sure you have backup of this registry entry first. Removing every key in the following registry key.  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Browser Helper Objects. Do not delete "Browser Helper Objects" key. Please be careful working with a registry, because you can make your computer not operational and would require reload OS. 

Posted in Errors, Windows | No Comments »

Extract Job History From SQL Server

February 19, 2008 – 6:36 am
Tested on SQL Server 2000 and 2005 SELECT sj.job_id,     job_name = sj.name,     status = CASE sjh.run_status WHEN 0 THEN 'Failed' WHEN 1 THEN 'Succeeded' WHEN 3 THEN 'Canceled' WHEN 4 THEN 'In-progress message' END,     sjh.message,     sjh.run_date,     sjh.run_time,     sjh.run_duration,     CASE sjh.run_date WHEN 0 THEN NULL ELSE     convert(datetime,             stuff(stuff(cast(sjh.run_date as nchar(8)), 7, 0, '-'), 5, 0, '-') + N' ' +             stuff(stuff(substring(cast(1000000 + sjh.run_time as nchar(7)), 2, 6), 5, 0, ':'), 3, 0, ':'),             120) END AS [StartTime],      DATEADD(second,sjh.run_duration,      CASE sjh.run_date WHEN 0 THEN NULL ELSE      convert(datetime,              stuff(stuff(cast(sjh.run_date as nchar(8)), 7, 0, '-'), 5, 0, '-') + N' ' +              stuff(stuff(substring(cast(1000000 + sjh.run_time as nchar(7)), 2, 6), 5, 0, ':'), 3, 0, ':'),              120) END)AS [EndTime],     sjh.server FROM msdb.dbo.sysjobhistory sjh     LEFT OUTER JOIN msdb.dbo.sysoperators so1  ON (sjh.operator_id_emailed = so1.id)     LEFT OUTER JOIN msdb.dbo.sysoperators so2  ON (sjh.operator_id_netsent = so2.id)     LEFT OUTER JOIN msdb.dbo.sysoperators so3  ON (sjh.operator_id_paged = so3.id),     msdb.dbo.sysjobs_view sj WHERE sjh.step_id = 0

Posted in SQL Server | No Comments »

MSI Switches

January 19, 2008 – 11:55 pm
Switch  Parameters                                Description -------------------------------------------------------------------------- /i      Package|ProductCode                       Installs or configures a                                                   product. /f      [p|o|e|d|c|a|u|m|s|v]Package|ProductCode  Repairs a product.                                                   p - Reinstalls a                                                   product only if a                                                   file is missing.                                                   o - Reinstalls a                                                   product if a file                                                   is missing or if an                                                   older version of a file                                                   is installed.                                                   e - Reinstalls a                                                   product if a file                                                   is missing or an equal                                                   or older version of a                                                   file is installed.                                                   d - Reinstalls a                                                   product if a file                                                   is missing or a                                                   different                                                   version of a file is                                                   installed.                                                   c - Reinstalls a                                                   product if a file                                                   is missing or the stored                                                   checksum value does not                                                   match the calculated                                                   value.                                                   a - Forces all files to                                                   be reinstalled.                                                   u - Rewrites all                                                   required user-                                                   specific registry                                                   entries.                                                   m - Rewrites all                                                   required                                                   computer-specific                                                   registry entries.                                                   s - Overwrites all                                                   existing shortcuts.                                                   v - Runs from the source                                                   file and re-caches the                                                   local package. /a   Package                                      Administrative                                                   ...

Posted in Batch file, Windows | No Comments »

Outlook journal stopped recording

January 8, 2008 – 1:29 am
Platform: WIndows XP SP2, Outlook 2003 on Exchange 2003.Got complaint from a user that outlook journal stopped recording office documents.Ran SCANPST.EXE utility in C:\Program Files\Common Files\System\MSMAPI\1033 to check and fix errors in .pst for Inbox.Then Tools -> Options -> Journal Options and did uncheck all files in [Also record files from] and checked [E-Mail Message] under  [Automatically record these items]. Closed Outlook. Opened Outlook again. In Journal Options I did check all files in [Also record files from] . Closed Outlook. Opened Outlook again Created MS Word file and MS Excel file and saved it. Now I was able to see files in Outlook Journal. I don't know what was a reason for this problem. I'm also not clear on why it took steps described above to fix the problem.... but it did work for me.   

Posted in Outlook, Windows, Windows XP | No Comments »

Get current working directory in bat file

January 2, 2008 – 4:57 pm
echo %CD% would display current working directory in cmd prompt.

Posted in Batch file, Windows | No Comments »

Defrag with reboot - batch file

December 16, 2007 – 10:04 pm
Platform tested: Windows XP and 2003  cd %windir%\system32 defrag C: -f shutdown.exe -s -t 5

Posted in Batch file, Windows | No Comments »

Replace text in set of files in folder - VB Script

December 16, 2007 – 10:00 pm
'this script is created by Roman Feldblum  set fso = CreateObject("Scripting.FileSystemObject")  'set shell = CreateObject("Wscript.Shell")  ' shell.Exec "cscript //h:cscript //s"  'set shell=nothing if WScript.Arguments.count = 3 then  if fso.FolderExists (WScript.Arguments(0)) then  'WScript.Arguments(0)   set folder = fso.GetFolder(WScript.Arguments(0))     for each file in folder.files    set stream = fso.OpenTextFile (WScript.Arguments(0) & "\" & file.name,1)    if not stream.AtEndOfStream then     text = ""     text = stream.ReadAll     set stream = nothing     if err.number = 0 then      text = Replace(text,WScript.Arguments(1),WScript.Arguments(2))      set stream = fso.OpenTextFile (WScript.Arguments(0) & "\" & file.name,2)      'Wscript.Echo fso.GetExtensionName(WScript.Arguments(0) & "\" & file.name)       if err.number = 0 then        stream.Write text       end if      stream.close      set stream = nothing     end if    else     set stream = nothing    end if   next   Wscript.Echo "DONE"  else   WScript.Echo ("Folder:" & WScript.Arguments(0) & " does not exists...")   WScript.Echo ("The usage is:" & vbcrlf & "ReplaceString.vbs arg1 arg2 arg3 arg4(optional)" & vbcrlf _    & " where:" & vbcrlf & "arg1 = folder path (C:\MyFolder)" & vbcrlf _    & "arg2 = string to be replaced" & vbcrlf _    & "arg3 = string to replace with" & vbcrlf _    & "arg4 = file extension (optional)")  end if '****************************************************************************************** elseif WScript.Arguments.count = 4 then  if fso.FolderExists (WScript.Arguments(0)) then  'WScript.Arguments(0)   set folder ...

Posted in VB Script, Windows | No Comments »