Do you know what parameters need to be supplied at the Java level to get a successful connection? If so, we can try and work out how to get that through the Saxon layer. If you don't know, then it's probably worth while trying to get it working directly from Java before you try to get it working from XSLT - that removes one layer of uncertainty from the system.

I assume you've googled around and found posts like this one:

http://stackoverflow.com/questions/167464/can-i-connect-to-sql-server-using-windows-authentication-from-java-ee-webapp

Michael Kay
Saxonica




On 01/12/2012 22:48, Mats Eklund wrote:
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



------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d


_______________________________________________
saxon-help mailing list archived at http://saxon.markmail.org/
saxon-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/saxon-help