> I'm setting up a new computer (Win 2K Professional) and some
> queries that work on other computers do not work on this one.
> The problem queries involve concatenation or setting constants
> in the query. The problem happens with Access 97 and 2000
> databases. Running CF 4.5.1 Professional.
>
> Select Field1 + Field2 as Field3....
> Select 'X' as Field1..... (but Select 0 as Field1 works)
> Select Field1 & Field2 as Field3...
>
> All of the queries work in Access, just not in <CFQuery>. All
> the queries work on my old Win NT computer which is basically
> running the same software and they work on another Windows
> 2000 computer.
>
> What is happening is that the browser just hangs when the
> query is run. I have to hit stop on the browser and then stop/start
> the CF service.
This is a documented, well-known MDAC bug with Win2K SP1:
http://www.allaire.com/Handlers/index.cfm?ID=17421&Method=Full
You can use Allaire's patch, but you might instead try upgrading your Win2K
machine to MDAC 2.6, available from:
http://www.microsoft.com/data/
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
