PHP 4.0.x and Openlink ODBC and OpenIngres, on Solaris

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 php-install-help@lists.php.net wrote: > Hi! This is the ezmlm program. I'm managing the > php-install@lists.php.net mailing list. > > I'm working for my owner, who can be reached > at php-install-owner@lists.php.net. > > Acknowledgment: I have added the address > > andre.felipe@embrapa.br > > to the php-install mailing list. > > Welcome to php-install@lists.php.net! > > 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: > <php-install-help@lists.php.net> > > To subscribe to the list, send a message to: > <php-install-subscribe@lists.php.net> > > 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: > <php-install-unsubscribe@lists.php.net> > > or for the digest to: > <php-install-digest-unsubscribe@lists.php.net> > > 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: > > <php-install-owner@lists.php.net> > > 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: <Andre.Felipe@embrapa.br> > 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 > <php-install-sc.999715957.milafapmdcfoojbnancm-andre.felipe=embrapa.br@lists.php.net>; 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 > <php-install-sc.999715957.milafapmdcfoojbnancm-andre.felipe=embrapa.br@lists.php.net>; Wed, 5 > Sep 2001 15:23:54 -0300 (EST) > Message-ID: <3B966DB8.5140248C@sede.embrapa.br> > Date: Wed, 05 Sep 2001 15:23:52 -0300 > From: Andre Felipe <Andre.Felipe@embrapa.br> > X-Mailer: Mozilla 4.76 [en] (Win98; U) > X-Accept-Language: en > MIME-Version: 1.0 > To: php-install-sc.999715957.milafapmdcfoojbnancm-andre.felipe=embrapa.br@lists.php.net > Subject: Re: confirm subscribe to php-install@lists.php.net > References: <999715957.14787.ezmlm@lists.php.net> > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > php-install-help@lists.php.net wrote: > > > Hi! This is the ezmlm program. I'm managing the > > php-install@lists.php.net mailing list. > > > > I'm working for my owner, who can be reached > > at php-install-owner@lists.php.net. > > > > To confirm that you would like > > > > andre.felipe@embrapa.br > > > > added to the php-install mailing list, please send > > an empty reply to this address: > > > > php-install-sc.999715957.milafapmdcfoojbnancm-andre.felipe=embrapa.br@lists.php.net > > > > 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:php-install-sc.999715957.milafapmdcfoojbnancm-andre.felipe=embrapa.br@lists.php.net > > > > 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 > > <php-install-request@lists.php.net> 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: > > <php-install-help@lists.php.net> > > > > To subscribe to the list, send a message to: > > <php-install-subscribe@lists.php.net> > > > > 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: > > <php-install-unsubscribe@lists.php.net> > > > > or for the digest to: > > <php-install-digest-unsubscribe@lists.php.net> > > > > 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: > > > > <php-install-owner@lists.php.net> > > > > 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: <root@php2.chek.com> > > 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: <20010905181619.15327.qmail@php2.chek.com> > > To: php-install-subscribe-andre.felipe=embrapa.br@lists.php.net > > Subject: Website Subscription > > From: andre.felipe@embrapa.br > > > > This was a request generated from the form at > > http://www.php.net/support.php. > > -- > André Felipe M. Carvalho > Analista de Sistemas - Embrapa / DTI > Postmaster@sede.embrapa.br > 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 Postmaster@sede.embrapa.br http://www.embrapa.br --------------------------- Os internautas escolheram a Embrapa como Top Cadê. Veja o resultado! http://www.topcade.com.br/ciencia/votacienciaMar2001.shtm