> well if you don't mind a 3rd party jdbc driver, have you > looked at jTDS? > you can add trusted authentication as simply as adding > domain to the jdbc url: > > jdbc:jtds:sqlserver://<dbServer>:1433/<dbName>;user=<domainUse > r>;password=<domainUserPassword>; > sendStringParametersAsUnicode=<true>;domain=<yourDomain> > > and it's most likely a bit faster than other jdbc drivers.
Not to say anything bad about jTDS, but I recently tried these drivers for a site that was using the latest DataDirect drivers. The jTDS drivers seemed to reduce memory utilization overall, but under load they failed outright. So I'd recommend that, for any database drivers you want to try, you may want to ensure that they'll work well for your site under the load that you expect to encounter. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217900 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
