You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cocoon.apache.org by Marcello Granata <mg...@matrix.it> on 2000/02/22 16:48:01 UTC

Query problems

Hi,
I've got the following conf:
winnt 4.0
iis 4
cocoon 1.6.1
xerces 1.0.1.
xalan 0.19.2

i've got the following problem

cocoon tells me:
***************************
<?xml version="1.0" encoding="UTF-8" ?> 
- <page>
  <sqlerror message="No data found" /> 
</page>
**************************


when it processes the following xml file:
***************************
<?xml version="1.0"?>

<?cocoon-process type="sql"?>
<?cocoon-format type="text/xml"?>

<page>
<connectiondefs>
 <connection name="pippo">
  <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
  <dburl>jdbc:odbc:virgilio</dburl>
  <username>prova</username>
  <password>prova</password>
 </connection>
</connectiondefs>
<query connection="pippo">
 select * from mydb
</query>
</page>
*************************

Everything is correct in my odbc configuration because i've got no problem in executing the query from another application.
Maybe it's a trivial question but ... anyone can help me?

Thanks
marcello