I'm using CDATA's ODBC driver to connect to sage50, when my software was in dev mode we had the license on my single machine.
We then transferred it to a server and ever since any ODBC connections can just time out.
For example :
<?php
$num_minutes = 10;
ini_set('max_execution_time', (60*$num_minutes));
$conn = odbc_connect("CData Sage50UK Source", "mysageusername", "mysagepass");
$query = odbc_exec($conn, "SELECT * FROM TradingAccounts where Name like '%LINEN DIRECT LIMITED%' limit 1");
while($row = odbc_fetch_array($query)){
$json1[] = array_map('utf8_encode', $row);
}
echo json_encode($json1);
?>
this query could work 1000 times before it times out, or it could work once - there is just nothing i can find to go off what might be doing this.
Once it does get suck, i cant use sage to restart SData, i have to use taskfind and taskkill in CMD, then starting sdata again through sage.
Anyone any ideas?
