PHP ODBC connecting

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello,

Our DBA has made some table views available for ODBC, and using the DSN for D3/pick, I can connect to them in UPS Worldship just fine, for what I need.

In the past, I used a lightweight client to view this data, again using the same DSN, and it has worked out well, letting me browse the table data.

So, now I want to make some of this data available on a Intranet page, for notifications (ex: open orders). I have a simple PHP script that runs and connects using the DSN, and based on the error I get, it looks like it connects alright, but I am somehow missing the proper commands?

Here is what I get when I run this:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Raining Data][ODBC D3 Driver]Syntax error, SQL state 37000 in SQLExecDirect in C:\wamp\www\components\com_jumi\jumi.php(25) : eval()'d code on line 9

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in C:\wamp\www\components\com_jumi\jumi.php(25) : eval()'d code on line 12

Hi, I'm running! 

And here is my script: 

<?PHP 

$connect = odbc_connect("FORESITE_VIEW", "KEY", "");

$query = "SELECT ORDER_NO, SHIPTO_NAME FROM KEY.ORDERINFO";

$result = odbc_exec($connect, $query);

while(odbc_fetch_row($result)){ $ORDER_NO = odbc_result($result, 1);

$SHIPTO_NAME = odbc_result($result, 2);

print("$ORDER_NO $SHIPTO_NAME"); }

print "Hi, I'm running!";

odbc_close($connect); ?> 

I know my server is ok, as the PHP prints "Hi, I'm running!", but as to the error... I am at a loss?

Any insight?

Thanks,

Tachi