I'm new to Sage and ODBC connections in general, so I'm looking for a bit of help here. I have set up a System DSN on the server, and am able to get a successful connection using PHP. However, whenever I try to run any sort of query, it doesn't pull any results.
Here is some code I'm working with to try and get something to display. I do get the "Connection is successful" message, but nothing after that. Please help!!!!
$rConn = odbc_connect("SageODBC", MyUsername, MyPassword);
if (!$rConn) {
die('Unable to connect to the Sage datasource.');
}
else
{
echo "Connection is successful<br />";
$result = odbc_tables($rConn);
$tables = array();
while (odbc_fetch_row($result))
array_push($tables, odbc_result($result, "TABLE_NAME") );
foreach( $tables as $t ) {
echo "$t\n";
}
}