I'm accessing some data from a url using (Microsoft.XMLHTTP).This page have some data like headline, source, author etc.
Once i get these data , i separate these headline, source etc. and insert in the database. I'm getting the perfect result. everything is working fine.
The scene is like that first i insert data at my server with the help of some admin section. Then i fetch the data from this database and populate (suppose last five records) at a given url ( www.abc.com
Then at the other server (www.xyz.com
) i request the page (www.abc.com
) and parse the data and insert it in the the database of (www.xyz.com
Now the problem begins here:----------
When first time i access the page if there are some new records available, it perfectly insert all the records.
now no new records are available so i add some another record and again refresh the page of ther server and again the record is inserted. This way i am able to insert records as long as i first insert some record at my database and after that only refresh the page at other server.
The problem begins when i refresh the page at other server and no new data is available at our server.After that although i add new records to my database , it could not be retrieved at the other server as the XMLHTTP is returning blank.
And now the very surprising thing....................
i could not able to fetch it through out the day but the very next day when i fetch the url all the new records perfectly get inserted and the whole process start as i mentioned before.
Any suggestion why this is happening, how can i rectify it.