Try to "echo $query;" and then see if there is any typo in the query itself... i work that way with php/mysql and most of the cases where i find such an error is some sort of typo in the query...
Cheers... Luis Ferro
Joseph McDonald wrote:
Here is the code (acct # blurred for obvious reason): ##begin paste## <?php $connect = odbc_connect("testcusa","",""); $query = "SELECT ACCT.DIVRATE, ACCT.BEG_DATE, ACCT.END_MATR, ACCT.CDPY_COD, ACCT.CDPMTRM, ACCT.CDFLTRM, ACCT.OCERTBAL, NAME.NAME, NAME.SSN, ACCT.\"ACCT#\", ACCT.SFX FROM ACCT ACCT, NAME NAME WHERE ACCT.\"ACCT#_JOIN\" = NAME.\"ACCT#_JOIN\" AND ((ACCT.\"ACCT#\"=\'******\') AND (ACCT.SFX Like \'M\'))"; $result = odbc_exec($connect, $query); odbc_result_all($result); ?> ##end paste##
Here is the result: ##being paste## Warning: SQL error: [Simba Technologies Inc.][SimbaEngine C/S ODBC Driver][SimbaClient][SimbaClient LNA]Client RPC error. Error = (103) Error sending message. Trap = (111) Error closing connection. Value = (533) Endpoint in incorrect state. State = CLOSE_STATE. , SQL state 08S01 in SQLConnect in C:\Program Files\Apache Group\Apache2\htdocs\CD\query.inc on line 5
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Apache Group\Apache2\htdocs\CD\query.inc on line 5
Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in C:\Program Files\Apache Group\Apache2\htdocs\CD\query.inc on line 6 ##end paste## The server is a custom Simba database wrote to access cfam databases on a RS/6000 box. I can pull info from this database using ODBC Explorer, MSQry tool, and several others, but PHP just will not give me back any data. I keep getting this error message. I have searched online and with no evail. If anyone can help me with this, I would greatly appreciate it. I am doing my best to learn PHP & several database systems but this has put a bump in my road. PHP's ODBC does work, I've connected using openlink and progress server on the same RS/6000 box to a diff database.
Thanks in advance
Joe
I
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
