> Dave, unfortunately the problem with MDAC is that CF5 > seems to require a low version (2.5SP1) not a high one > (see KB 21664), whereas SQL 2000 seems to require 2.6 > or higher (2.6 gets installed with SQL2K).
I know that we've successfully run Advanced Security against SQL Server 2000, though. It's been a while, so I don't remember the exact details, but we did run into the problem documented in the KB and were able to resolve it. Here's what I'd try: 1. First, if you've already installed MDAC 2.6, download and install the latest release version, which is MDAC 2.7 RTM. 2. If you haven't, you might simply try connecting with 2.5 SP2 - after all, you only have to install MDAC 2.6 on the machine running SQL Server. I'm not sure you need 2.6 simply to connect to an SQL Server 2000 machine. 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 ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
