Hi,

Finally, I got xml_odbc running, but it does not really work well for me. I am getting:
2009-08-28 03:33:47.459383 [ERR] mod_xml_odbc.c:325 Stopped rendering template, called xml_odbc_render_template more than [32] times, probably looping.
2009-08-28 03:33:47.459383 [ERR] mod_xml_odbc.c:408 Something went horribly wrong while generating an XML template!

My config is:
<configuration name="xml_odbc.conf" description="XML ODBC Configuration">

<settings>
        <param name="binding" value="directory"/>
    <param name="odbc-dsn" value="class5_odbc:root:JdqB-S"/>
    <param name="debug" value="true"/>
    <param name="keep-files-around" value="true"/>
</settings>

<templates>

    <template name="default">
      <document type="freeswitch/xml">
        <section name="directory">
     <xml-odbc-do name="query" on-empty-result-break-to="not-found" value="SELECT enabled, sip_password FROM agent WHERE sip_user = ${user}"/>
        <domain name="${domain}">
          <user id="${user}">
            <params>
              <xml-odbc-do name="query" value="SELECT sip_password FROM agent WHERE sip_user = ${user}">
                <param name="password", value="${sip_password}"/>
              </xml-odbc-do>
            </params>
              </user>
        </domain>

        </section>
      </document>
    </template>

</templates>

</configuration>

Since these two queries get data from the same table, I tried to merge them, but could not get it to work.

Anyone has any idea?

Thanks,
JB