Hi all

I'm trying to make a connection with Sql Server.
can anybody tell me:
how are the drivers that I have to use and where do I have to put them?
I've tried with:

In the web.xml file I have added:
         <init-param>
        <param-name>load-class</param-name>
        <param-value>
                        <--JDBC:ODBC-->
                         com.ms.jdbc.odbc.JdbcOdbcDriver
              </param-value>
         </init-param>

In the cocoon.xconf:
         <jdbc name="nombres">
                <dburl>jdbc:odbc:10.100.1.2:1433:Databases/Pruebas</dburl><!--I think 
this is wrong
                <user>sa</user>
                <password>jdbccon</password>
         </jdbc>

In the sitemap.xmap:
        <map:match pattern="sql/*">
                <map:generate src="docs/samples/sql/{1}.xml"/>
                <map:transform type="sql">
                <map:parameter name="use-connection" value="nombres"/>
                </map:transform>
                <map:transform src="stylesheets/simple-sql2html.xsl"/>
                <map:serialize/>
        </map:match>

please can anyone help me?
Thanks...

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Reply via email to