Menu
▾
▴
Re: [Rlib-users] ODBC text
|
From: Bob D. <bd...@si...> - 2004-12-08 13:58:07
|
Can you run it from the command line so I can see the exact error
messages?
- bob
On Wed, 2004-12-08 at 06:52 -0300, Cl=C3=A1udio Fortier wrote:
> Of course. There are the scrip and xml files:
>=20
> array_oracle.php
> <? dl ("librlib.so");
> $rlib =3D rlib_init();
> rlib_add_datasource_odbc($rlib, "odbcsusfacil", "u_susfacil", "u_susfa=
cil");
> rlib_add_query_as($rlib, "odbcsusfacil", "select * from ten_pac_pacien=
te", "ten_pac_paciente");
> rlib_add_report($rlib, "array_oracle.xml", "ten_pac_paciente");
> rlib_set_output_format_from_text($rlib, "pdf");
> rlib_execute($rlib);
> header(rlib_get_content_type($rlib));
> rlib_spool($rlib);
> rlib_free($rlib);
> ?>
>=20
> array_oracle.xml
> <?xml version=3D"1.0"?>
> <!DOCTYPE report >
> <Report fontSize=3D"9" orientation=3D"landscape">
> <Alternate>
> <NoData>
> <Output>
> <Line fontSize=3D"12">
> <literal>NO DATA</literal>
> </Line> =09
> </Output>
> </NoData>
> </Alternate>
> <ReportHeader>
> <Output>
> <Line fontSize=3D"11">
> <literal>Test Report (Normal) AND THE REPORT FORMAT IS: </literal>
> <field value=3D"r.format" width=3D"20"/>
> <field value=3D"eval('1+2')" width=3D"20"/>
> </Line>
> <Line fontSize=3D"11">
> <literal bold=3D"yes">Test Report (Bold)</literal>
> </Line>
> <Line fontSize=3D"11">
> <literal italics=3D"yes">Test Report (Italics)</literal>
> </Line>
> <Line fontSize=3D"11">
> <literal bold=3D"yes" italics=3D"yes">Test Report (Bold and Italics=
)</literal>
> </Line>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> </Output>
> </ReportHeader> =09
> <Breaks>=09
> <Break name=3D"break0" newpage=3D"no" headernewpage=3D"yes">
> <BreakHeader>
> <Output>
> <Line>
> <field value=3D"group" width=3D"20" align=3D"left" col=3D"1"/> =
=09
> </Line>
> </Output> =09
> </BreakHeader>
> <BreakFields>
> <BreakField value=3D"group"/>
> </BreakFields>
> <BreakFooter>
> <Output>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> <HorizontalLine size=3D"2" bgcolor=3D"'black'"/>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> <Line>
> <field value=3D"group" width=3D"20" align=3D"left" col=3D"1"/> =
=09
> </Line>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> <HorizontalLine size=3D"2" bgcolor=3D"'black'"/>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> </Output>
> </BreakFooter>
> </Break>
> </Breaks>
> <Detail>
> <FieldHeaders>
> <Output>
> <HorizontalLine size=3D"1" bgcolor=3D"'black'"/>
> <Line bgcolor=3D"'0xe5e5e5'">
> <literal width=3D"20" col=3D"1">First Name</literal>
> <literal width=3D"1"/>
> <literal width=3D"20" col=3D"2">Last Name</literal>
> <literal width=3D"1"/>
> <literal width=3D"20" col=3D"3">Color</literal>
> </Line>
> <HorizontalLine size=3D"1" bgcolor=3D"'black'"/>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> </Output>
> </FieldHeaders> =09
> <FieldDetails>
> <Output>
> <Line bgcolor=3D"iif(r.detailcnt%2,'0xe5e5e5','white')">
> <field value=3D"PAC_PK_INT_CODIGO" width=3D"20" align=3D"left" col=
=3D"1"/>
> <literal width=3D"1"/>
> <field value=3D"PAC_CHR_NOME" width=3D"20" align=3D"left" col=3D"2=
"/>
> <literal width=3D"1"/>
> <field value=3D"PAC_CHR_TELEFONE" width=3D"20" align=3D"left" col=3D=
"3"/>
> </Line>
> </Output>
> </FieldDetails>
> </Detail>
>=20
> <PageFooter>
> <Output>
> <Line>
> <literal>Page: </literal>=09
> <field value=3D"r.pageno" width=3D"3" align=3D"right"/>
> </Line>
> </Output>
> </PageFooter>
>=20
> <ReportFooter>
> </ReportFooter>
> </Report>
>=20
>=20
> ------------------- reply ---------------
> > From: bd...@si...
> > To: cfo...@ib...
> > Cc: rli...@li...
> > Subject: Re: [Rlib-users] ODBC text
> > Date: 2004-12-07 18:15:15
> > ----------------------------------
> > Can I see the php file you created for RLIB causes the error?
> >=20
> > - bob
> >=20
> > On Tue, 2004-12-07 at 17:52 -0300, Cl=C3=83=C2=A1udio Fortier wrote:
> > > Hi, Bob.
> > >=20
> > > I'm using Linux RedHat 8.
> > >=20
> > > Yes the PHP standalone ODBC test works.
> > >=20
> > > The PHP RLIB example array.php works too.
> > >=20
> > > There is the RLIB configuration:
> > >=20
> > >=20
> > > rlib-1.3.0:
> > >=20
> > > prefix: /usr/local
> > > compiler: gcc
> > > Memory debugging: no
> > > Warning Fun: no
> > > Crash detection: yes
> > > UTF8 disabled: no
> > >=20
> > > INPUTS:
> > > MYSQL: yes
> > > POSTGRE: yes
> > > ODBC: yes
> > >=20
> > > OUTPUTS:
> > > PDF: yes
> > > HTML: Always
> > > CSV: Always
> > > TEXT: Always
> > >=20
> > > BINDINGS:
> > > PHP: yes
> > > PHP entension dir: /usr/local/lib/php/extensions/no-=
debug-non-zts
> > > -20020429
> > > PYTHON: no
> > > PYTHON version: 2.2
> > > PYTHON entension dir:
> > > JAVA: no
> > > PERL: no
> > > PERL entension dir:
> > >=20
> > > Music: Velvet Revolver
> > >=20
> > > Having Problems: rli...@li...
> > > Want to contribute: rli...@li...
> > >=20
> > >=20
> > >=20
> > > ------------------- reply ---------------
> > > > From: bd...@si...
> > > > To: cfo...@ib...
> > > > Cc: rli...@li...
> > > > Subject: Re: [Rlib-users] ODBC text
> > > > Date: 2004-12-07 10:52:16
> > > > ----------------------------------
> > > >=20
> > > > So the PHP standalone ODBC test works?
> > > >=20
> > > > Also, when you ./configure rlib there is a screen at the end sayi=
ng how
> > > > RLIB is configured. Can you send that to me
> > > >=20
> > > > Also what distro are you using?
> > > >=20
> > > > On Mon, 2004-12-06 at 19:32 -0300, Cl=C3=83=C6=92=C3=82=C2=A1udio=
Fortier wrote:
> > > > > Hi Bob, thanks for your response.
> > > > >=20
> > > > > I really need access ORACLE, but rlib have no native access for=
it. Because this, i'm trying use unixODBC.
> > > > >=20
> > > > > unix ODBC works fine with the folow script:
> > > > > <html>
> > > > > <body>
> > > > >=20
> > > > > <?php
> > > > > $conn=3Dodbc_connect('oracle','u_test','u_test');=20
> > > > > if (!$conn)
> > > > > {
> > > > > exit("Connection Failed: " . $conn);=20
> > > > > }=20
> > > > > $sql=3D"SELECT * FROM TEN_PAC_PACIENTE";=20
> > > > > $rs=3Dodbc_exec($conn,$sql);=20
> > > > > if (!$rs)
> > > > > {=20
> > > > > exit("Error in SQL");
> > > > > }=20
> > > > > echo "<table><tr>";
> > > > > echo "<th>C=C3=83=C6=92=C3=82=C2=B3digo</th>";
> > > > > echo "<th>Nome</th></tr>";
> > > > > while (odbc_fetch_row($rs))
> > > > > {
> > > > > $CODIGO=3Dodbc_result($rs,"PAC_PK_INT_CODIGO");
> > > > > $NOME=3Dodbc_result($rs,"PAC_CHR_NOME");
> > > > > echo "<tr><td>$CODIGO</td>";
> > > > > echo "<td>$NOME</td></tr>";
> > > > > }
> > > > > odbc_close($conn);
> > > > > echo "</table>";
> > > > > ?>
> > > > >=20
> > > > > </body>
> > > > > </html>
> > > > >=20
> > > > > ------------------- reply ---------------
> > > > > > From: bd...@si...
> > > > > > To: for...@ya...
> > > > > > Cc: rli...@li...
> > > > > > Subject: Re: [Rlib-users] ODBC text
> > > > > > Date: 2004-12-06 14:41:30
> > > > > > ----------------------------------
> > > > > > I haven't used it since I wrote it
> > > > > >=20
> > > > > > does any other app work w/ the unixodbc??
> > > > > >=20
> > > > > > - bob
> > > > > >=20
> > > > > > On Mon, 2004-12-06 at 08:41 -0300, Claudio Fortier wrote:
> > > > > > > Hi, i'm trying use rlib with unixodbc and PHP in linux
> > > > > > > rh8. Someone has used rlib with unixodbc? I need
> > > > > > > examples.=20
> > > > > > >=20
> > > > > > > My tests every returns the message "The connection was
> > > > > > > refused when attenpting to contact www.localhost.com"
> > > > > > >=20
> > > > > > > Please, help me.=20
> > > > > > >=20
> > > > > > >=20
> > > > > > > =09
> > > > > > > =09
> > > > > > > =09
> > > > > > > _______________________________________________________=20
> > > > > > > Yahoo! Mail - Agora com 250MB de espa=C3=83=C6=92=C3=86=E2=80=
=99=C3=83=E2=80=9A=C3=82=C2=A7o gratuito. Abra=20
> > > > > > > uma conta agora! http://br.info.mail.yahoo.com/
> > > > > > >=20
> > > > > > >=20
> > > > > > > -------------------------------------------------------
> > > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > > Read honest & candid reviews on hundreds of IT Products fro=
m real users.
> > > > > > > Discover which products truly live up to the hype. Start re=
ading now.=20
> > > > > > > http://productguide.itmanagersjournal.com/
> > > > > > > _______________________________________________
> > > > > > > Rlib-users mailing list
> > > > > > > Rli...@li...
> > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >=20
> > > > > >=20
> > > > > >=20
> > > > > > -------------------------------------------------------
> > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > Read honest & candid reviews on hundreds of IT Products from =
real users.
> > > > > > Discover which products truly live up to the hype. Start read=
ing now.
> > > > > > http://productguide.itmanagersjournal.com/
> > > > > > _______________________________________________
> > > > > > Rlib-users mailing list
> > > > > > Rli...@li...
> > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >=20
> > > > >=20
> > > >=20
> > > >=20
> > > >=20
> > > > -------------------------------------------------------
> > > > SF email is sponsored by - The IT Product Guide
> > > > Read honest & candid reviews on hundreds of IT Products from real=
users.
> > > > Discover which products truly live up to the hype. Start reading =
now.
> > > > http://productguide.itmanagersjournal.com/
> > > > _______________________________________________
> > > > Rlib-users mailing list
> > > > Rli...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >=20
> > >=20
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real use=
rs.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20
>=20
|
