Hi,

I am having problem with the SQL extension element getting some data from a SQL Server DB using the following approach (note authentication method used):

            <sql:connect driver="'sun.jdbc.odbc.JdbcOdbcDriver'" database="'jdbc:odbc:Driver={SQL Server};Server=FOO;Database=BAR;Trusted_Connection=Yes'">
                <xsl:fallback>
                    <xsl:message terminate="yes">SQL extensions are not installed</xsl:message>
                </xsl:fallback>
            </sql:connect>

When I run this I get the following error:

Description: (SQL) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'User'.

Is it not possible to use windows integrated authentication?

Thanks for any advice!

Mats