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]

Reply via email to