Solution for R net Communication Error

Do the following steps to rectify this problem
1. Go to the folder C:\windows\System32\drivers\etc ( if you have installed windows on D partition  then the path will be like D:\windows\System32\drivers\etc)
2. Open the file “Hosts” file using notepad
3. There will be an entry like the following inside the hosts file
 127.0.0.1       localhost
 Add one more entry below.
 218.248.43.143 regnnet.ptcmysore.gov.in

-
With Regards

Help Desk
PTC

Sanchay post error cant run in client machine

Click here  https://www.dropbox.com/s/0mv5lupqfbn7hd8/Update_SQL2008.zip

SQL Server backward tool

Click here

r net data final for APS

 office master data for APS Link Click Here

first download file from above said link- r net data final for APS-WO Manraj Singh (Word File)

emo pin code and office name file

emo update for APS

Speed Net Upgradation 3.1.2 to 4.1.1.zip

Speed Net Upgradation 3.1.2 to 4.1.1.zip for APS 

Click Here

r net office master data

click here

SID QUERY

1. Run Query Analyzer
    Select POST database and Exceute the following command

    Select sid from sysusers where name = 'DCL'

    Eg. The result like this 0xB7165F12378..........
   
    Copy this value

2. Execute these commands one by one
   
    sp_configure 'allow updates', 1    Highlight the query Press Ctrl E
   
    reconfigure with override     Press Ctrl E

3. Select Master databse and excute the following statements:

    Update sysxlogins set sid = <Paste previous copied value  eg. 0xB7165F12378.........>
    where name = 'DCL'

4. Execute these commands one by one
   
    sp_configure 'allow updates', 0    Highlight the query Press Ctrl E
   
    reconfigure with override Press Ctrl E

sanchay post day begin after many days

USE POST
DELETE FROM DCL.DAYBEGIN
DELETE FROM DCL.LAST_WORKING_DAY
DELETE FROM DCL..SI_EXEC_UPDATE

POINT OF SALE ARTICLE NOT FETCHED IN SPEED NET

Speed Post Articles were booked in Point of Sale does not fetched in Speed Net Module, after Configure DOP Server.

Solution

Solution 1 : POS booked articles not fetching in speed net module after changing the server name or formatting the server

Run these two queries in SQL query analyzer one by one

sp_configure 'show advanced options',1
go
reconfigure

sp_configure 'Ad Hoc Distributed Queries',1
go
reconfigure

Solution 2 :

Right click on server name in SQL management studio->facets-> surface area configuration.
Set true to Ad hoc remote queries.

AP-150 unblocking user

use [ap-150]
update dbo.tblmtuser set isblock = 'false' where isblock = 'true'