Thank you for all your replies! At the moment for the development phase, I use the JDBC driver provided by Microsoft. It is not very fast but it works.
For information the driver is: Microsoft SQL Server 2000 Driver for JDBC. I use the URL: jdbc:microsoft:sqlserver:your_server:1433:DatabaseName=your_database;SelectMethod=cursor;User=username;Password=password You don't need to specify the JDBC driver (com.microsoft. ...); 1433 is the default port number. This URL works fine. Sylvain -----Message d'origine----- De: Bertrand Delacretaz [mailto:[EMAIL PROTECTED]] Date: lundi, 14. octobre 2002 11:26 á: [EMAIL PROTECTED]; ThÊvoz Sylvain, IT-DCS-CPS-CLI-DAR Objet: Re: Cocoon and hsqldb On Monday 14 October 2002 11:18, [EMAIL PROTECTED] wrote: >. . . > Has someone tried to connect Cocoon to a Microsoft SQL Server database? > I'm looking for a database URL connection example. >. . . If you're courageous you can use the JDBC-ODBC bridge for this, but last time I checked it was fairly limited and funky (or do they have native JDBC now?). I don't have an URL handy but you should find it in the JDBC-ODBC samples. I've also used www.inetsoftware.de's excellent (commercial) drivers for MS SQL, you'd then use a JDBC URL like: jdbc:inetdae:your_server:1433?database=your_db A nice utility to test these URLs and JDBC drivers is DBVisualizer, http://www.minq.se/products/dbvis/info.html Hope this helps. -Bertrand --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
