如何使用PHP连接到Sage 50 ODBC数据库

Question

I'm attempting to export data from Sage 50 database. I have managed to create a connection to the database however whenever I perform a query I have the following error message.

Warning: odbc_exec(): SQLColAttribute can't handle SQL_DESC_OCTET_LENGTH: [S1C00] Driver not capable in C:... on line 4

I have Attempted to change the cursor to SQL_CUR_USE_CODE as suggested on PHP.net

I am also sure it is connecting as when I enter a table name that doesn't exist then I am receiving this error.

Warning: odbc_exec(): SQL error: Table not found, SQL state S0002 in SQLExecDirect in C:... on line 4

$conn = odbc_connect("TestDB", "Manager", "", SQL_CUR_USE_ODBC);
$sql="SELECT * FROM STOCK"; 
$result=odbc_exec($conn,$sql);

Thanks in advance