I have also tried this with just "SELECT * FROM ACCT" ACCT holds all member account information. I am trying to write a form where someone here can create a CD on our core system, and then go to this form and type in the account number and suffix of that CD and print out the certificate of deposit terms and conditions form without having to input any information, less human error factor.
Joe "Luis Ferro" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I just got lost in the query string... > > 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
