Hi there, has anyone researched which ODBC driver is most stable with CF 5
and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and
this query will crash CF to 100% CPU every time I run it:
<CFQUERY datasource="#request.mainDSN#" Name="ViewAssignment">
SELECT
ASSIGNMENTS.num_contentid AS contentid,
ASSIGNMENTS.dat_start AS dat_start,
ASSIGNMENTS.dat_due AS dat_due,
ASSIGNMENTS.bit_complete AS bit_complete,
ASSIGNMENTS.txt_description AS txt_description,
CONTENT.contenttitle AS title,
CONTENT.editable AS editable
FROM ASSIGNMENTS, CONTENT
WHERE
ASSIGNMENTS.num_contentid = CONTENT.contentid AND
ASSIGNMENTS.num_contentid = #attributes.contentid#
ORDER BY ASSIGNMENTS.dat_due
</CFQUERY>
I'm not exactly sure which MDAC is installed. Is it advisable to update to
the most recent MDAC even though we're not running SQL 2000 yet? I noticed
on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/
Thanks for any of your help.
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
