I've got a small test program that reads a remote file using ODBC with a
local system DSN :-
<?php
session_cache_limiter('nocache');
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
?>
<html>
<meta http-equiv="refresh" content="10">
<?php
if (!$link_id = odbc_connect ('secpay','','')) die("Failed to connect to RMS
database"); //Links to database
var_dump(odbc_error($link_id));
var_dump(odbc_errormsg($link_id));
echo "connected to secpay!!\n";
$sql = "SELECT * from dist_write:secpay;";
$exec = odbc_exec($link_id, $sql);
var_dump(odbc_error($link_id));
var_dump(odbc_errormsg($link_id));
var_dump($exec);
odbc_result_all($exec);
?>
The program reads the rows without a problem, but if I delete the source
file, the script continues to return the rows and doesn't show any errors.
I believe this to be an issue around IIS. If I execute 'IISRESET' to restart
the service, the script starts to return 'No Rows' instead.
Does anyone know how I can force IIS to stop caching this query/PHP script,
and always read the file?
Rob.
***********************************************************************************
Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient
or entity to who they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
Random House Group + 44 (0) 20 7840 8400
http://www.randomhouse.co.uk
http://www.booksattransworld.co.uk
http://www.kidsatrandomhouse.co.uk
Generic email address - enquiries@xxxxxxxxxxxxxxxxx
Name & Registered Office:
THE RANDOM HOUSE GROUP LIMITED
20 VAUXHALL BRIDGE ROAD
LONDON
SW1V 2SA
Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980
***********************************************************************************
