Hello friends, I compiled PHP 4.0.x with iodbc support (using Openlink 4.0 drivers) to access OpenINGRES 2.0, all this on Sun Solaris (2.6 or 2.8). When I try some little test the odbc_connect is ok (resource id is #1), but.... no matter what query I try, the odbc_prepare or odbc_exec always return the error: SQL error: [OpenLink][ODBC][Ingres Server]E_US09C5 line 1, Syntax error on '2,3'. (-31000), SQL state S1000 in SQLPrepare There's no '2,3' on my query.... The ODBC trace debug shows the error as: generic_ingresii: ** E_US09C5 line 1, Syntax error on '2,3'. (-31000) generic_ingresii: scs_p_GetTblAttribs: DRV_DDTables failed (srhtb002). Any of you had this problem? any of you have an environment like mine (Solaris, Openlink ODBC, Openingres 2.0 and PHP 4 ) working ok? For illustration, this same installation (Solaris, Openlink ODBC 4.0, Openingres 2.0) , but with PHP 3.0.12, works REAL NICE. So, the problem is with PHP 4 or with Openlink ODBC drivers? Thanks in advance, André Felipe [EMAIL PROTECTED] wrote: > Hi! This is the ezmlm program. I'm managing the > [EMAIL PROTECTED] mailing list. > > I'm working for my owner, who can be reached > at [EMAIL PROTECTED] > > Acknowledgment: I have added the address > > [EMAIL PROTECTED] > > to the php-install mailing list. > > Welcome to [EMAIL PROTECTED]! > > Please save this message so that you know the address you are > subscribed under, in case you later want to unsubscribe or change your > subscription address. > > --- Administrative commands for the php-install list --- > > I can handle administrative requests automatically. Please > do not send them to the list address! Instead, send > your message to the correct command address: > > For help and a description of available commands, send a message to: > <[EMAIL PROTECTED]> > > To subscribe to the list, send a message to: > <[EMAIL PROTECTED]> > > To remove your address from the list, just send a message to > the address in the ``List-Unsubscribe'' header of any list > message. If you haven't changed addresses since subscribing, > you can also send a message to: > <[EMAIL PROTECTED]> > > or for the digest to: > <[EMAIL PROTECTED]> > > For addition or removal of addresses, I'll send a confirmation > message to that address. When you receive it, simply reply to it > to complete the transaction. > > If you need to get in touch with the human owner of this list, > please send a message to: > > <[EMAIL PROTECTED]> > > Please include a FORWARDED list message with ALL HEADERS intact > to make it easier to help you. > > --- Enclosed is a copy of the request I received. > > Return-Path: <[EMAIL PROTECTED]> > Received: (qmail 16093 invoked from network); 5 Sep 2001 18:54:30 -0000 > Received: from unknown (HELO mamona.sede.embrapa.br) (200.202.168.1) > by pb1.pair.com with SMTP; 5 Sep 2001 18:54:30 -0000 > Received: from arroz.sede.embrapa.br (arroz.sede.embrapa.br [10.10.10.31]) > by mamona.sede.embrapa.br (8.11.3/8.11.3) with ESMTP id f85INtC00725 > for ><[EMAIL PROTECTED]>; > Wed, 5 Sep 2001 15:23:55 -0300 (EST) > Received: from sede.embrapa.br (pc10106.sede.embrapa.br [10.10.10.106]) > by arroz.sede.embrapa.br (8.11.0/8.11.0) with ESMTP id f85INsv19439 > for ><[EMAIL PROTECTED]>; > Wed, 5 Sep 2001 15:23:54 -0300 (EST) > Message-ID: <[EMAIL PROTECTED]> > Date: Wed, 05 Sep 2001 15:23:52 -0300 > From: Andre Felipe <[EMAIL PROTECTED]> > X-Mailer: Mozilla 4.76 [en] (Win98; U) > X-Accept-Language: en > MIME-Version: 1.0 > To: >[EMAIL PROTECTED] > Subject: Re: confirm subscribe to [EMAIL PROTECTED] > References: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > [EMAIL PROTECTED] wrote: > > > Hi! This is the ezmlm program. I'm managing the > > [EMAIL PROTECTED] mailing list. > > > > I'm working for my owner, who can be reached > > at [EMAIL PROTECTED] > > > > To confirm that you would like > > > > [EMAIL PROTECTED] > > > > added to the php-install mailing list, please send > > an empty reply to this address: > > > > >[EMAIL PROTECTED] > > > > Usually, this happens when you just hit the "reply" button. > > If this does not work, simply copy the address and paste it into > > the "To:" field of a new message. > > > > or click here: > > >mailto:[EMAIL PROTECTED] > > > > This confirmation serves two purposes. First, it verifies that I am able > > to get mail through to you. Second, it protects you in case someone > > forges a subscription request in your name. > > > > Some mail programs are broken and cannot handle long addresses. If you > > cannot reply to this request, instead send a message to > > <[EMAIL PROTECTED]> and put the > > entire address listed above into the "Subject:" line. > > > > --- Administrative commands for the php-install list --- > > > > I can handle administrative requests automatically. Please > > do not send them to the list address! Instead, send > > your message to the correct command address: > > > > For help and a description of available commands, send a message to: > > <[EMAIL PROTECTED]> > > > > To subscribe to the list, send a message to: > > <[EMAIL PROTECTED]> > > > > To remove your address from the list, just send a message to > > the address in the ``List-Unsubscribe'' header of any list > > message. If you haven't changed addresses since subscribing, > > you can also send a message to: > > <[EMAIL PROTECTED]> > > > > or for the digest to: > > <[EMAIL PROTECTED]> > > > > For addition or removal of addresses, I'll send a confirmation > > message to that address. When you receive it, simply reply to it > > to complete the transaction. > > > > If you need to get in touch with the human owner of this list, > > please send a message to: > > > > <[EMAIL PROTECTED]> > > > > Please include a FORWARDED list message with ALL HEADERS intact > > to make it easier to help you. > > > > --- Enclosed is a copy of the request I received. > > > > Return-Path: <[EMAIL PROTECTED]> > > Received: (qmail 14779 invoked from network); 5 Sep 2001 18:52:35 -0000 > > Received: from unknown (HELO php2.chek.com) (208.247.106.187) > > by pb1.pair.com with SMTP; 5 Sep 2001 18:52:35 -0000 > > Received: (qmail 15328 invoked by uid 99); 5 Sep 2001 18:16:19 -0000 > > Date: 5 Sep 2001 18:16:19 -0000 > > Message-ID: <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Subject: Website Subscription > > From: [EMAIL PROTECTED] > > > > This was a request generated from the form at http://www.php.net/support.php. > > -- > André Felipe M. Carvalho > Analista de Sistemas - Embrapa / DTI > [EMAIL PROTECTED] > http://www.embrapa.br > --------------------------- > Os internautas escolheram a Embrapa como Top Cadê. > Veja o resultado! > http://www.topcade.com.br/ciencia/votacienciaMar2001.shtm -- André Felipe M. Carvalho Analista de Sistemas - Embrapa / DTI [EMAIL PROTECTED] http://www.embrapa.br --------------------------- Os internautas escolheram a Embrapa como Top Cadê. Veja o resultado! http://www.topcade.com.br/ciencia/votacienciaMar2001.shtm -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]