I have a little problem. This
PHP code works fine on Apache/UBUNTU but not in IIS7/Windows 2008
//SQL Script
$sql = "SELECT MTWO_WIP_SSTART, BKIC_PROD_TYPE
FROM BKICMSTR INNER JOIN WORKORD ON BKICMSTR.BKIC_PROD_CODE = WORKORD.MTWO_WIP_CODE
WHERE MTWO_WIP_PROJ LIKE 'W%' AND MTWO_WIP_STATUS = 'R' ORDER BY MTWO_WIP_SSTART ASC";
//conneccion
$conn=odbc_connect('DBA','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
?>
I thing is a pervasive issue, because the following works fine to connect to an MS SQL Express 2008 on the same server
$ID = $_REQUEST['ID'];
//--Get Value
$conn=odbc_connect('UMCDB','user_all','nopassuser');
$var_sql="SELECT web_hits FROM web_stats WHERE web_index=$ID";
$rs=odbc_exec($conn,$var_sql);
$new_val=odbc_result($rs,"web_hits")+1;
//--Update Record
//$var_sql="UPDATE web_stats SET web_hits=$new_val WHERE web_index=$ID";
//$rs=odbc_exec($conn,$var_sql);
Kelloggs