Is there any PHP code that demonstrates how to access data from the Remedy AR server using the Remedy ODBC driver?


my current code is this:
-------------------------------------------------------
<?php
$msserver="Remedy ODBC Data Source";
$usrname="Demo";
$passwrd="XXXXX";
$conn=odbc_connect($msserver,$usrname,$passwrd);
$result = odbc_exec($conn, "SELECT * FROM SuN-Ticket");
while (odbc_fetch_row($result))
{
$standort = odbc_result($result, "An Standort");
$erstellt = odbc_result($result, "Erstellt am");
echo "$standort und $erstellt <br>";
}
odbc_close($conn);
?>
-----------------------------------------------
the failure I get:

Warning: odbc_exec(): SQL error: [ISAM]No data found, SQL state S00 in SQLExecDirect in C:\Inetpub\wwwroot\uhd\test.php on line 7

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in C:\Inetpub\wwwroot\uhd\test.php on line 8

I haven't seen any examples yet, but you could try using ARSPHP to access Remedy data... it's available in my download area http://www.mattreinfeldt.com/apps/index.php?action=file&id=129

Maybe that will help you.

Check out the eleGantt php-script code at
http://www.erwe.se/eleGantt/

It uses the ar system odbc-driver.