Also try restarting the CF ODBC services. There are two of them in the services control panel.
> -----Original Message----- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Thursday, November 19, 2009 5:04 PM > To: cf-talk > Subject: RE: CF8, Vista, SQL 2005 > > > Just a guess, but maybe do some maintenance on the database. Try a > shrink. Rebuild the indexs. > > Is the database from SQL 2005 or an earlier version? > > Sound like it is more on the CF end than the database through. > > Check the DSN setting in CFadministrator also. Remove it and add it back > using the default settings. > > > > -----Original Message----- > > From: A D [mailto:alandeans2...@yahoo.co.uk] > > Sent: Thursday, November 19, 2009 4:43 PM > > To: cf-talk > > Subject: Re: CF8, Vista, SQL 2005 > > > > > > Its around 40 columns - none of them text or ntext. > > > > I cant see any problems with disk space. > > > > 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:328536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4