November 09, 2012

TNEB Fetching error

Point of sale module, most of the time TNEB bills are not fetching properly. general errors are

1. return with go sub - this one has rectified in newer version
2.error getting data
    - due to tneb server problem
    - Slow internet connectivity problem
    - ePayment client problem

try this one

Give following settings on ePayment client

[webserver: services.ptcmysore.gov.in port: 80
virtual path: epaymentOL ]


Recover MSDB in SQL 2005

1.        Put MSSQL into single user mode
1.        Click -> START -> Microsoft SQL Server 2005 -> Configuration Tools – > SQL Server Configuration Manager

2.       Right click on SQL Server and choose Properties

3.       Click on the Advanced tab. Under Startup Parameters you will be adding the following parameters to the beginning of the string: -m;-c;-T3608

2.       Restart SQL Server
3.       Connect to SQL server through the Management Console. From this point on we will be using TSQL to issue the commands so click the New Query button on the top left. At this point you should be in the master database inside the query window.
4.       Detach the MSDB database using the following commands:
use master
go
sp_detach_db ‘msdb’
go
and click Execute



5.        We need to move (or rename, I prefer moving them) the existing MDF and LDF files for the MSDB database so that we can recreate it.
1.        Usually these files are located in the following directory:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataYour’s might differ.
2.       Move (or rename) the MSDBDATA.mdf and MSDBLOG.ldf files.
6.       Back to the Management Studio. Open up the instmsdb.sql file in a new query window. This file is usually located in the following directory:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install
7.        Execute the file. If you see any errors about xp_cmdshell, just ignore them. They are common and the script will take care of it.
8.       At this point you should have your MSDB database restored. The only thing left is cleanup.
9.       Execute the following command to make sure that xp_cmdshell is once again set to disable for security reasons:
EXEC sp_configure ‘show advanced options’, 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure ‘xp_cmdshell’, 0
GO
RECONFIGURE WITH OVERRIDE
GO
10.     Shutdown SQL Server
11.      Go back into your Startup Paremeters for your server in the SQL Server Configuration Manager and removed the -c;-m;-T3608 parameters we added earlier.
12.     Restart SQL Server

DBAnalyzer for Sanchay Post Dated 08-11-2012

Software Development Centre, Chennai

DBAnalyzer for Sanchay Post
 


 
Email issues related to this software to sblansupport@hotmail.com

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

Server User "dcl" is not a valid user in database "NREGAEMO"

After the installation of sanchay post version 7.0 when you restore the databases and logon to sanchay post, if the error messages shown above will come please run the patch .  The problem is that login for NREGAEMO data base is not created in server.


 
run the patch attached:  Upg_user_Nrega.exe

Team Viewer for Life time Free version


Team viewer trail period extended

Automatic change of ID program TeamViewer.
Changers ID TeamViewer-and uses 2 files:

ReID_TV.bat

@ Echo Off
echo Stoping TeamViewer
:: Stop TeamViewer
net stop "teamviewer 5
:: Kill TeamViewer
echo Killing TeamViewer
taskkill / f / im teamviewer *
nircmdc closeprocess TeamViewer.exe
:: Delete ID from Registry
echo Deleting ID from Registry
nircmdc regdelval "HKEY_LOCAL_MACHINE Software TeamViewer Version5" "ClientID"
echo Change Program Files map date
:: Change Date of Program Files map
nircmdc setfilefoldertime "% programfiles%" now now
:: Start TeamViewer
echo Starting TeamViewer
net start "teamviewer 5
:: Show TeamViewer
nircmdc exec show "% ProgramFiles% TeamViewer Version5 TeamViewer.exe"
nircmdc.exe - from developers NirSoft.

For convenience, was created SFX-archive, self extracting. Its just need to run and ID replaced.

Download Click her Change ID

Related Posts Plugin for WordPress, Blogger...
Related Posts Plugin for WordPress, Blogger...