DB Analyzer Revised 28/02/2013

DB Analyzer Revised 28/02/2013

DBAnalyzer Admin   February 28, 2013

DB Analyzer revised version released on 28-feb-2013 by SDC Chennai.

To Download Revised DB_Analyzer.exe

Software Development Centre
O/o the Chief Postmaster General
Tamilnadu Postal Circle
Chennai - 600002
Phone: 044-65850861

Database Creation Error: SQL Connection Failed

Database Creation Error: SQL Connection Failed

usefulpost Admin   February 28, 2013

Error:

        Some times while creating Database by using our Dept. Software's i.e Point of sale, subaccount, treasury, postman, eMO, Speednet, etc., it Shows an error messages as

"Connection to the SQL Server failed. The server name may be wrong or the UserId or Password Entered may be incorrect. Check the status of the SQL Server also."

Solution:

1.Above error occurs wrong selection of authentication while sql server 200/2005/2008 installation.

2. To overcome above problem, Right click SQL server Server properties in Enterprise Manager.

3. Then go to Security Tab > Select SQL Server and Windows Authentication then Click ok then click Yes for Restart SQL server to take effect.

4. After restart SQL server User login sa will be created then Goto Security > Logins> Sa right click properties to change password.

Now Your sql server ready to connect for database creation with our dop softwares.

Smart Driver Backup Tool v2.12

Smart Driver Backup Tool v2.12

usefulpost Admin   February 25, 2013

This is the simplest Tool to Back up your Computer Drivers,Including BSNL Broadband USB Modem Driver,LAN,Display,Audio,Printer and any other Divers.

Smart Driver Backup is a efficient device drivers backup software that successfully back up your Windows device drivers. Backing up your Windows driver files means they will be available to you the next time where you need to reinstall the driver or the whole operating system. 

SQL Server 2000 installation fails with "...previous program installation..."

SQL Server 2000 installation fails with "...previous program installation..."

windows 2003 server update Admin   February 23, 2013

Error:
        SQL Server 2000 installation fails with "...previous program installation..." error message

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system.

Solution:

• Restart the computer and see if you are able to run the setup. If the restart does not help, use the steps that follow.
• Perform these steps and then run the SQL Server 2000 setup again:
• Click Start, and then click Run.
• In the Open dialog box, type: "Regedit" (without the quotation marks) or "Regedt32" (without the quotation marks)
• Click OK.
• NOTE: Please make sure that you only delete the value mentioned, not the whole session manager key.
• In Registry Editor, expand the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager 
• On the File menu, click Export.
• NOTE: In Microsoft Windows 2000, click Export Registry File from the Registry menu.
• In the File name text box, type: "Session Manager Key" (without the quotation marks) 
• Click Save.
• In the right-pane of the Registry Editor window, right-click PendingFileRenameOperations. On the shortcut menu that appears, click Delete.
• In the Confirm Value Delete message dialog box that appears, click Yes.
• On the File menu, click Exit.

NOTE: In Windows 2000, click Exit on the Registry menu.

Restart the computer.
Using the Registry Editor, verify that the PendingFileRenameOperations registry value is not available.

Note: The PendingFileRenameOperations registry value may be re-created when you restart the computer. If the registry values are re-created, delete the PendingFileRenameOperations registry value again by completing steps a through j, and then run SQL Server 2000 Setup. Do not restart the computer before you run SQL Server 2000 Setup.

Generic Host Process For Win32 Services Encountered

Generic Host Process For Win32 Services Encountered

windows 2003 server update Admin   February 20, 2013

Error:
Generic Host Process For Win32 Services encountered a problem and needs to close

Generic Host Process Error causes certain applications like Internet Explorer crash, this is really annoying when some important application crashes.

Solution:

The Generic host problem has been happening because of a Windows Error. For the same we suggested a fix by running the tool above. This tool may case problems with LAN access to other computers in a LAN kind of network environment. We regret the inconvenience occurred to you because of this LAN Access Problem. If you are facing such problem, please follow the below two steps to fix the issue :

1. Download attached batch file and run as administrator.

2. Download corresponding OS Microsoft website and Execute Hot fixes

eMO Client Server Connection error

eMO Client Server Connection error

sql error Admin   February 20, 2013

Error:
       While Register/Execute eMO Client it shows error message "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

(or)

"Login failed for user ''.

Solution:

• Download attached eMO Client.exe
• Replace Old eMO Client.exe
• Open for Register/Execute eMO client.exe

SBCO 63/85 Registers Preparation Tool

SBCO 63/85 Registers Preparation Tool

SBCO Utility Admin   February 19, 2013

SBCO 63/85 Registers Preparation Tool 

To Download:

Developed by
R.Karunagaran
System Manager
Tirupattur HPO – 635601
9894213404
Karunagaran78@Gmail.com

ERROR:
      Run-time error '339':
           Component 'DBGRID32.OCX' or one of its depencies not correctly registered: a file is missing or invalid.

Solution:

• Download Attached DBGRID.OCX file from potools.
• Copy and paste DBGRID.OCX file into C:\Windows\System32 Folder (C:\ - Windows OS drive)
• Register .OCX file by using resvr32.exe

Sanchay Post: NSC Issue error

Sanchay Post: NSC Issue error

usefulpost Admin   February 19, 2013

Error:
         While issue nsc in sanchay post module it shows an error "Run applkication nsc_pk_patch.exe". 

Solution:

• Download Below Patch file 
• Execute from DB Analyser folder

eMO Client 701,702 invalid object 'File Received'

eMO Client 701,702 invalid object 'File Received'

usefulpost Admin   February 18, 2013

Error:
       While execute eMO Client it Shows an error messages 

701 Invalid object Name 'File Received'

702 Invalid object name 'File Received' Invalid file name 'WorkerRecords'

Solution:
            Above error occurs when Improper upgradation of sanchay post 7.0 i.e NREGA Database not properly updated.

• Check the status of upgradation of Ver 7.0 in the latest DBAnalyzer and intimate results.
• For newly configured server restore NREGA Database(From old backup)
• After Restore NREGA Database update dcl using below query

• then execute eMO Client it shows an error login failed for user NREGA, to overcome this error   

• Thats all. Now your eMO Client will execute smoothly without any error

Change Font in EPSON LX-300+ Printer

Change Font in EPSON LX-300+ Printer

printer Admin   February 16, 2013

We can change the font on Epson LX-300+ printer by setting up the panel buttons on the printer.

To change font in Epson LX-300+ Printer is as follows :

• Switch on the Printer.
• Hold the Pause Button for 3 Seconds (until you here a beeb sound).
• Now you see the pause LED blinks, now you press Font button to change the font (you here beep sound on change of each font).
• After selecting the font press pause button once.
• Now your font has been changed.

MMC cannot open the file SQL Server Enterprise Manager

MMC cannot open the file SQL Server Enterprise Manager

usefulpost Admin   February 14, 2013

ERROR:
Upon clicking on the SQL Server Enterprise Manager shortcut the following error occurs:

MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.

This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file.

Solution:
Method 1: Permanent Solution 

• Select Start -> Run.
• At the Open prompt enter: mmc

• Click OK
• Select File - Add/Remove Snap-in

• Click Add...
• Select Microsoft SQL Enterprise Manager

• Click Add, then Close
• Click Ok to return to the mmc.
• Select File - Save As...

• Delete or rename the original (offending) file out the way.
• Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
• Now your original shortcut should work.

Method 2: Temporary Solution

• Right click SQL Enterprise Manager - Run as Administrator

• Click ok to Run.

R Net Communication Error in C Class Offices

R Net Communication Error in C Class Offices

RNet Communication Admin   February 13, 2013

In C class offices while execute  rnet communication shows error "object reference not set to an instance of an object". 

To Solve C Class Office RNet Communication Problem

• Download and execute below exl 

• Download RNet Communication exe file and Replace Old one

Treasurer Query timeout Expired error

Treasurer Query timeout Expired error

writer Admin   February 12, 2013

Error:
       While view monthly report in Treasury supervisor (C Class office) it shows an error "Query timeout expired"

Solution:

• It may be index errors for a BOSubAccounts database 
• Close all meghdoot applications completely
• Download and Run attached script using script tool
• Check for the monthly report through Treasury Option

Note: After execute above exl, we are not able to do remittance adjustment in Subaccounts in C Class office.

Problem not Solved visit: http://potools.blogspot.com/2013/03/treasury-monthly-report-timeout-expired.html

------------------------------------------------------------------------------------------------

A Great Thank to 

Sharmila Sethupathi(Writer POTOOLS)

System Administrator.

Enable eVP for Invoice and Authorise in Postman

Enable eVP for Invoice and Authorise in Postman

usefulpost Admin   February 12, 2013

While login as Postman supervisor Authorisation of misdirected EVPs  is disabled. 

To Enable Authorization of misdirected EVP in postman super

• Postman Supervisor -> My Office -> Users -> Modify tab.
• Select user and tick "EVP Articles" options.

• Restart postman module and login as SPM to authorize misdirected EVPs.

Upgrade SQL 2000 to SQL 2008 R2

Upgrade SQL 2000 to SQL 2008 R2

usefulpost Admin   February 11, 2013

Install .Net frame work and Windows Installer 4.5

Install SQL Server 2008R2 and hotfix(SQLServer2008R2_RTM_CU3_2261464_10_50_1734_x86 )

Download and install hotfix

Take the full Backups of all Databases form SQL Server 2000 

Transfer the Logins- download sql file run on query analyzer in sql 2000

sql query

Copy result and paste on sql 2008 R2 run the result query to transfer login such as counterpa, etc.,

Take Transactional backups of all databases

Stop the SQL Server 2000

Create Newalias name for SQL Server 2008r2 which suppose same as SQL Server 2000  and  assign port as 1433
Restored in SQL Server 2008 R2 with NO RECOVER(to reduce the Down time).

Restore Transactonal backup with with Recovery.