SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also.
Chad > -----Original Message----- > From: A D [mailto:alandeans2...@yahoo.co.uk] > Sent: Thursday, November 19, 2009 11:27 AM > To: cf-talk > Subject: CF8, Vista, SQL 2005 > > > Hi, > > I have CF8 installed on a Vista laptop using SQL Server 2005. I can > connect to the datasource from CF but my queries appear to timeout or hang > when using 'SELECT *'. Using 'SELECT colA, colB.....' seems to work. > > I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. > > Any help appreciated. > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4