I made some tests with JDBC drivers from Microsoft and ESQL and they
worked fine. Anyway, I find the XML method suggested by Josephine
Massey-Frenard very interesting. I'm going to experiment a bit.
Thanks you all!
Gianluca
Il ven, 2003-10-24 alle 22:54, [EMAIL PROTECTED] ha scritto:
hi people
Hi,
You can use standard JDBC, but there is a more interesting approach.
SQL Server can output XML, and can be accessed directly over HTTP.
To get an XML output from the SQL simply write FOR XML at the end of a
SELECT statement. You can give three qualifiers to this:
FOR XML RAW (this returns
Hi,
i have been asked to create a small html reporting system for a msSQL
(microsoft) database. is it possible to connect cocoon with msSQL, is any
connector available out there ? (i'dont have touch msSQL before)
have a look at the wiki: http://wiki.cocoondev.org/Wiki.jsp?page=MsSQL
hth
--