> About the second question. I am using the "other" data source > feature, and I followed the instructions that were on this > page to set up the data source > .(http://www.fusioncube.net/index.php/coldfusion-sql-server-express ) > > The only way that I am verifying that it isn't working is > because of the error I copied above that cold fusion gives me > when I try to connect. I will get some screen shots when I get home.
First of all, I'm pretty sure that the latest database drivers available with CF do support SQL Server 2005, so you shouldn't need to even bother with all this. I don't know why I didn't just suggest that in the first place. Second, are you actually trying to connect to SQL Server 2005 Express? If so, make sure you've enabled TCP/IP and native SQL logins. Actually, the DataDirect drivers are supposed to support Windows authentication too, but it's just easier to use native SQL logins. 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;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
