> 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.
Why not enable native SQL logins and use those from CF? You can continue to use trusted connections from ASP.NET. The problem with using trusted connections from CF is that you have to run the CF service itself as the trusted Windows account, which is kind of limiting. > 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? It really depends a lot on your specific application. It might be a little slower, it might be a lot slower, it might even be faster! Generally, though, you want to avoid using unnecessary abstraction layers, which in this case would mean avoiding using JDBC to talk to ODBC to your database when you could just talk directly from JDBC to your database. > Are there any driver updates available from anywhere that > address this issue in the current drivers? You might be able to do this using the SQL Server JDBC driver from Microsoft. The DataDirect 3.3 driver used by CF actually supports trusted connections, but this functionality isn't exposed to CF in any obvious way (you might be able to add the appropriate information to neo-query.xml directly, but I haven't tried this nor would I recommend it in production). 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5100 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=11502.10531.10 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
