RE: Which version of MDAC is best with Cold Fusion 4.5.1
I have done this and it seems to work well however the procedure is rather cryptic. The documentation that comes with comcheck explains how to do this. Also be sure that you have the latest version of comcheck. We had an older version installed on one machine and it did not have a listing of the most recent files for the mdac we were attempting to check on. Kept telling us we had version 2.1 when we really had 2.5sp1. Good Luck. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 3:33 AM To: CF-Talk Subject: RE: Which version of MDAC is best with Cold Fusion 4.5.1 Here is where all of the various versions of MDAC are http://www.microsoft.com/data/download.htm The file name is MDAC_TYP.EXE (7.8megs) which sort self installs when run -- don't know about how well it works going backwards one version. Also, I don't know if there is a way to uninstall the version you now have before you install the older version. I don't think it's a good idea to simply install an older MDAC over a newer one. The Component Checker tool also available from the above URL allows you to uninstall MDAC, although I haven't tried it myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of MDAC is best with Cold Fusion 4.5.1
Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. Xing - Original Message - From: "Jeffry Houser" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 9:05 PM Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1 If it's working, don't change anything. I have ColdFusion and the latest version of MDAC (I'm pretty sure 2.5) running on my machines here just fine. Of course with only one user (me) you don't get a lot of server load. At 04:19 PM 02/27/2001 -0500, you wrote: I think I am currently run MDAC 2.1 (no patches) with Cold Fusion Profesional 4.5.1. Presently we are using ODBC against both VFP and Access databases/tables. Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the organization. Can and/or should I have our DBA upgrade to the 2.51.5303.5 version?? Will Cold Fusion play nice with 2.5, or should we go to the latest patched version of 2.1 ?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
What about 2.6a? Lanny Udey Hofstra University [EMAIL PROTECTED] Wednesday, February 28, 2001 Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable What about 2.6a? AFAIK, this still has a few issues - I would still stick with 2.5 (and I am) until it's proven that it works 100% Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Thanks for the very helpful and almost immediate feedback -- you guys are great... Seems concensus is that I should be running MDAC 2.5 with my present CF 4.5.1 and VFP/Access database environment. Conversly with SQL Server 2000 database backend, I should go to MDAC 2.6 and the latest patches for CF. Regarding Licensing of SQL Server 2000, I called Microsoft and they indicated all I really needed was one license of SQL Server 2000 -- since Cold Fusion is the user as far as SQL Server is concerned (not the 50 or more users hitting Cold Fusion via the net). Hence, at minimum, the Standard Edition of SQL Server 2000 (Part Number 228-00782) will do at a cost of $665.00 -- so they said. The Standard Edition of SQL Server also comes with the Personal Edition of SQL Server 2000 -- which may be the same version that ships with Visual Studio (hence free - sorta) and can be managed via Access 2000. Not sure on this last issue -- especially the how to part. Guess this means you can install the Standard Edition on your web server that folks in the hinterland access via your Cold Fusion app and also install the Personal Edition on your development box -- also for a cost of just $665. Did this doggie get it right??? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Say I have Win2k SP1 with MDAC 2.6 loaded on my server - how do I go about putting version 2.5 over that? Simple steps please - starting from "Go to the Microsoft web site, download..." Simon Park Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] wrote: AFAIK, this still has a few issues - I would still stick with 2.5 (and I am) until it's proven that it works 100% ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Here is where all of the various versions of MDAC are http://www.microsoft.com/data/download.htm The file name is MDAC_TYP.EXE (7.8megs) which sort self installs when run -- don't know about how well it works going backwards one version. Also, I don't know if there is a way to uninstall the version you now have before you install the older version. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Park, Simon [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 3:55 PM To: CF-Talk Subject:RE: Which version of MDAC is best with Cold Fusion 4.5.1 Say I have Win2k SP1 with MDAC 2.6 loaded on my server - how do I go about putting version 2.5 over that? Simple steps please - starting from "Go to the Microsoft web site, download..." Simon Park Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] wrote: AFAIK, this still has a few issues - I would still stick with 2.5 (and I am) until it's proven that it works 100% ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
On 2/28/01, Lanny R. Udey penned: If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable From what i read, it doesn't include drivers for the desktop database either, so I'd stick with 2.5 if you're running any Access, FoxPro, etc. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Thanks Bud -- critical point about 2.6 not liking Foxes... You know, if this ole doggie keeps associating with you folks, I'm going to be the smartest retired person on the planet... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Bud [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 4:51 PM To: CF-Talk Subject:RE: Which version of MDAC is best with Cold Fusion 4.5.1 On 2/28/01, Lanny R. Udey penned: If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable From what i read, it doesn't include drivers for the desktop database either, so I'd stick with 2.5 if you're running any Access, FoxPro, etc. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Here is where all of the various versions of MDAC are http://www.microsoft.com/data/download.htm The file name is MDAC_TYP.EXE (7.8megs) which sort self installs when run -- don't know about how well it works going backwards one version. Also, I don't know if there is a way to uninstall the version you now have before you install the older version. I don't think it's a good idea to simply install an older MDAC over a newer one. The Component Checker tool also available from the above URL allows you to uninstall MDAC, although I haven't tried it myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Which version of MDAC is best with Cold Fusion 4.5.1
I think I am currently run MDAC 2.1 (no patches) with Cold Fusion Profesional 4.5.1. Presently we are using ODBC against both VFP and Access databases/tables. Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the organization. Can and/or should I have our DBA upgrade to the 2.51.5303.5 version?? Will Cold Fusion play nice with 2.5, or should we go to the latest patched version of 2.1 ?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of MDAC is best with Cold Fusion 4.5.1
I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go to 4.52 RC2, or whatever the latest version is, it fixes the problems with MDAC 2.6 though. jon - Original Message - From: "Arden Weiss" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:19 PM Subject: Which version of MDAC is best with Cold Fusion 4.5.1 I think I am currently run MDAC 2.1 (no patches) with Cold Fusion Profesional 4.5.1. Presently we are using ODBC against both VFP and Access databases/tables. Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the organization. Can and/or should I have our DBA upgrade to the 2.51.5303.5 version?? Will Cold Fusion play nice with 2.5, or should we go to the latest patched version of 2.1 ?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of MDAC is best with Cold Fusion 4.5.1
- Original Message - From: "Jon Hall" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 10:58 PM I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go to 4.52 RC2, or whatever the latest version is, it fixes the problems with MDAC 2.6 though. What_is_the problem with MDAC 2.6? SQL Server 2000 also installs it by default - or a later release of it. Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Unless you're using SQL Server 2000, why not use MDAC 2.5? It tried and true (MDAC 2.6 hosed my machine two days ago). I wouldn't use 2.6 if you don't have a good reason to do so. ~Simon Simon Horwith Allaire Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 6:24 PM To: CF-Talk Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1 - Original Message - From: "Jon Hall" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 10:58 PM I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go to 4.52 RC2, or whatever the latest version is, it fixes the problems with MDAC 2.6 though. What_is_the problem with MDAC 2.6? SQL Server 2000 also installs it by default - or a later release of it. Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of MDAC is best with Cold Fusion 4.5.1
MDAC 2.6, which is also installed with Win2k SP1 reintroduced a previous bug that had been patched in earlier MDAC's. It basically hoses Access (specifically pass-thru queries) and some ADO stuff if I remember correctly. The newest patch for CF fixes these problems, so it is safe to upgrade the Win2k SP1 or manually put MDAC 2.6 on the system. I've done it. jon - Original Message - From: "Adrian Cooper" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 6:23 PM Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1 - Original Message - From: "Jon Hall" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 10:58 PM I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go to 4.52 RC2, or whatever the latest version is, it fixes the problems with MDAC 2.6 though. What_is_the problem with MDAC 2.6? SQL Server 2000 also installs it by default - or a later release of it. Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists