> I have just switched some CF applications over from an ODBC
> datasource to the SQLOLEDB provider on a Windows NT Server
> 4 machine, with Cold Fusion 4.01 Enterprise and SQL Server
> 7, and it all seems to run just fine.
>
> However - an_identical_in every respect configuration, but
> running under Windows 2000 Advanced Server seemingly won't
> run the CF apps at all - at least to any significant extent.
>
> The SQLOLEDB datasources to the CF databases verify fine on
> the Win2K machine.
>
> Win2K is, I think running MDAC 2.5, and in fact I have just
> upgraded the NT Server machine to MDAC 2.5 RTM and which again,
> runs everything fine.
>
> Has anyone encountered this problem before specifically with
> the CF SQLOLEDB provider and Windows 2000, and if so - what
> is the solution? CF 4.5?.
The CF installation breaks the version of MDAC which comes with Win2K, MDAC
2.5. Unfortunately, you can't just reinstall MDAC 2.5 on Win2K. Instead,
you'll have to "upgrade" Win2K to the latest version - which is probably
what you're already running. Just put the Win2K CD in, select "Upgrade your
current operating system", wait about half an hour through a couple of
reboots, click "OK" a bunch of times, and when you're done, reinstall any
drivers that didn't come with the Win2K distribution. After that, you
shouldn't have any problems with OLEDB. Of course, if you install CF again,
you might have to repeat the process!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
