Don't know if this will work, but you could try running a duff query against the datasource, if I recall it worked with access on cf4.5 when we needed to make any changes that included data. have a go and let me know how it goes!:)
----- Original Message ----- From: "Rich Wild" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 5:24 PM Subject: [ cf-dev ] CFUSION_DISABLE_DBCONNECTIONS > > Hi all, have never done this cos we've never needed to, but now a client > needs to use excel spreedsheets as a datasource. > > We've setup the dsns fine and can query the data, but to change the file we > obviously need to removed the cached connection to the workbook that CF > holds. > > I believe CFUSION_DISABLE_DBCONNECTIONS was made obsolete in CFMX. Is there > an alternative? > > ta. > > ------------------------------------------------------- > Rich Wild > Senior Web Developer > > ------------------------------------------------------- > e-mango Tel: 01202 755 300 > Gild House Fax: 01202 755 301 > 74 Norwich Avenue West > Bournemouth Mailto:[EMAIL PROTECTED] > BH2 6AW, UK http://www.e-mango.com > ------------------------------------------------------- > This message may contain information which is legally > privileged and/or confidential. If you are not the > intended recipient, you are hereby notified that any > unauthorised disclosure, copying, distribution or use > of this information is strictly prohibited. Such > notification notwithstanding, any comments, opinions, > information or conclusions expressed in this message > are those of the originator, not of e-mango.com ltd, > unless otherwise explicitly and independently indicated > by an authorised representative of e-mango.com ltd. > ------------------------------------------------------- > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
