Thanks for everyone's help... it was all useful, but I ended up sorting out connection pooling for MS SQL instead. In return (and to avoid more gumbies like me wasting everybody's time), here are instructions for how to get Microsoft SQL Server 7.0 to work with the Turbine distribution in Cocoon 1.8. Probably heresy on this list though ;-) It relies on the fact that the Sybase DBadaptor and the MSSQL DBadaptor are identical... Oh, and I only tested this with the (heinously expensive) Inet software JDBC type 4 driver.... and not exhaustively... on Cocoon1.8/Tomcat 3.1/Debian Linux. Here goes. 1) Comment out the line in cocoon.properties that says (with a #) processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver 2) and replace with processor.xsp.pool.database.adaptor.DBSybase=com.inet.tds.TdsDriver 3) Then set some connection params up (like the oracle example there already) i.e. something like... processor.xsp.pool.database.myexcitingwebproject.driver=com.inet.tds.TdsDriver processor.xsp.pool.database.myexcitingwebproject.url=jdbc:inetdae:localhost:1433?database=myexcitingwebproject processor.xsp.pool.database.myexcitingwebproject.username=uname processor.xsp.pool.database.myexcitingwebproject.password=pword processor.xsp.pool.database.myexcitingwebproject.maxConnections=3 processor.xsp.pool.database.myexcitingwebproject.expiryTime=3600000 4) Make sure that Sprinta2000.jar is in /jakarta-tomcat/lib/ and in yr. tomcat.bat if you have the misfortune of running windows... (3.1 on Linux picks it up automatically). 5) Stop Tomcat. 6) Start Tomcat. 7) If you are using the esql logic sheet (for example) simply replace yr params in the page with <esql:use-connection>myexcitingwebproject</esql:use-connection> et viola! Sorry if this is too obvious... however at least now everyone can dismissively refer people to the archives if they ask the same question ;-) Patrick At 08:45 30/10/2000 -0500, you wrote: >Your dbconnect.xml file isn't well-formed xml, and won't parse (no xml pi, no >root element). Why not just use an external entity to include your file? > >Best, >Hugh > >Patrick van Kann wrote: > > > Hello, > > > > Sorry for what must appear to be a fairly obvious/trivial problem, but I am > > having no success with getting <xincludes to, well, include anything. I > > have seen references to this problem in the archives but no solution... > > > > The code fragment below shows what I am trying to achieve. Can anyone see > > the (no doubt blindingly obvious) mistake I am making? Embarrassingly, I > > have struggled with this for 2 days and it's got me beat. > > > > Thanks, Patrick > > > > <?xml version="1.0"?> > > <?cocoon-process type="xinclude"?> > > <?cocoon-process type="xsp"?> > > <?cocoon-process type="xslt"?> > > <?xml-logicsheet href="esql.xsl"?> > > <?xml-stylesheet href="form4.xsl" type="text/xsl"?> > > > > <xsp:page > > language="java" > > xmlns:esql="http://apache.org/cocoon/SQL/v2" > > xmlns:util="http://www.apache.org/1999/XSP/Util" > > xmlns:xsp="http://www.apache.org/1999/XSP/Core" > > xmlns:xinclude="http://www.w3.org/TR/xinclude" > > > > > > > <page> > > > > <esql:execute-query> > > <xinclude:include parse="xml" xinclude:href="dbconnect.xml"/> > > <esql:results> > > > > The dbconnect.xml just contains... > > > > <esql:driver>My.database.driver</esql:driver> > > <esql:dburl>my.database/URL</esql:dburl> > > <esql:username>uname</esql:username> > > <esql:password>pword</esql:password> > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org > > For additional commands, e-mail: cocoon-users-help@xml.apache.org > >-- >/* >* Hugh A. Cayless >* Academic Web Developer, UNC College of Arts and Sciences >* Project Manager, UNC Digital Library Project >* 919-843-6260 >*/ > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org >For additional commands, e-mail: cocoon-users-help@xml.apache.org