jTDS SQL Driver

[jeff_gombala]

Can somebody point me to any articles, blogs, etc that discuss how to use the jTDS drivers with CFMX 7, including installing and any configuration?

Thanks,

Jeff

[PaulH]

setup is fairly easy, drop the jar (latest version is 1.1) into
cfinstall\wwwroot\web-inf/lib, chose other for the datasource then:

jdbc URL:
jdbc:jtds:sqlserver://dbServer:dbPort/dbName;user=userName;password=password
;{sendStringParametersAsUnicode=true};{domain=wind owsDomain}

driver class: net.sourceforge.jtds.jdbc.Driver

leave the rest of that dialog blank. if you use the domain option on the URL,
then the user & password should be for that windows domain. that's about it. it
behaves like the datadirect driver as far as cfquery goes.