Chad I think the datasource connection is ok as I can select single individual columns in a query.
Thanks > 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:[email protected]] > > 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:328525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
