> Indeed the MS driver only supports TCP/IP as a communication > protocol and SQL Server authentication.
While all that may be true, we were talking about the DataDirect Connect driver shipped with CFMX, not the MS driver. > You could, however use jTDS: it works both over TCP/IP and > named pipes and supports three types of authentication > (SQL Server, Windows authentication providing a user name > and password and Windows authentication using a native > Single Sign On library). I wasn't aware of all that. In the case of Windows authentication using a native SSO library, do you have to run CFMX as the specific Windows user against which you want to perform authentication? > jTDS is also more stable and a faster than the MS driver. Have you performed benchmarks to this effect? Can you share the benchmark results and the steps you went through to perform your tests? How does it compare to DataDirect and JTurbo? 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:196686 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54