Have you tried using OLE DB or a Dynamic query with a connection string? ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com
-----Original Message----- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC 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. ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
