> We're running CFMX7 and SQL Server 2000 in Windows2003 > Server. I know there are a variety of ways that one can get > CF to talk to a SQL Server box: ODBC, JDBC, Named Pipes, and > so on. I don't even pretend to know what all of that really > means. The question is what's the best practice these days? > I think at one point, ODBC was faster, but then JDBC was > recommended, and now I'm no longer sure.
ColdFusion only supports JDBC, so you'll be using JDBC. You can either use a "pure Java" JDBC driver, or you can connect to ODBC datasources using SequeLink as a JDBC proxy of sorts. I'd strongly recommend using just JDBC. JDBC requires that your SQL Server be configured to listen on TCP/IP. It doesn't support Named Pipes. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
