There is a fix for those others affected by this issue (quite a few of you as it happens): You will need to re-register MDAC at the Command line. Perform the following commands one after the other keeping the quotes in the last 2: regsvr32 c:\winnt\system32\atl.dll regsvr32 "c:\program files\common files\system\ole db\oledb32.dll" regsvr32 "c:\program files\common files\system\ole db\sqloledb.dll" Once this is performed your OLEDBs will work fine. ------------------------------------------------------- Rich Wild Senior Web Designer ------------------------------------------------------- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, 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. ------------------------------------------------------- > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 30 November 2000 09:13 > To: CF-Talk > Subject: SP2 install killed our OLEDBs! > > > On our dev servers we installed SP2 ontop of CF 4.5.1. > > Several of our sites use OLEDB DSNs to SQL 7 databases. > > These have now *all* failed. Checking the passwords, setting > up new dsn's > all fail. We can now do nothing through OLEDB. > > ODBC dsn's are unaffected. > > ouch. > > Anyone had any similar experiences? > > ------------------------------------------------------- > Rich Wild > Senior Web Designer > > ------------------------------------------------------- > e-mango.com ltd Tel: 01202 587 400 > Lansdowne Place Fax: 01202 587 401 > 17 Holdenhurst Road > Bournemouth Mailto:[EMAIL PROTECTED] > BH8 8EW, 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. > ------------------------------------------------------- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Structure your ColdFusion code with Fusebox. Get the official > book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/[email protected]/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
