ODBC到SAGE 50帐户数据服务

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?