Hi all, I am currently setting up a new development environment using Coldfusion MX Server, SQL server 2000 and Windows Server 2003. The development environment will be running both Coldfusion & ASP.NET applications. I need the ASP.NET application to connect to the database using WIndows Authentication only and so I have configured my SQL server security authentification setting to be windows only. This works fine for my ASP.NET apps but Coldfusion throws a wobbly.
At the moment I have configured my database connections in Coldfusion admin to use the 'Microsoft SQL server'. I found the following at Macromedia website 'In Macromedia ColdFusion versions 5 and under, the "Use Trusted Connection" option allowed Microsoft SQL Server to authenticate users based on their Windows domain logins. The "Trusted Connection" option is not supported by the DataDirect JDBC 3.0 SQL Server driver that ships with ColdFusion MX or the DataDirect JDBC 3.2 SQL Server driver that ships with ColdFusion MX 6.1. This TechNote explains how to enable a "Trusted Connection" in ColdFusion MX and higher, using the ODBC Socket driver. To enable the "Trusted Connection" option in the ODBC Socket driver, you must: Configure an ODBC data source using the ODBC Driver Manager. Configure an ODBC Socket data source in the ColdFusion MX administrator. Note: The ODBC SOCKET is a JDBC Type 3 driver which translates JDBC calls into the middle-tier server, which then translates the request to the database-specific native-connectivity interface. Because database-specific code must be executed in the middle-tier, the ODBC SOCKET Type 3 driver does not perform as fast as the Microsoft SQL Server Type 4 driver which converts JDBC calls into the network protocol used directly by the database.' These are a few questions that I have; Configuring an ODBC data source using the ODBC driver manager, does anyone have any experience of what amount of performance degradation can be expected? Are there any driver updates available from anywhere that address this issue in the current drivers? Does anybody know of any other way of creating windows authentificated connections? Any help, as always, greatly appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5099 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/10 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
