Hello, list!
I'm not quite sure that this is the right place to ask, but I'm having problems getting MySQL and ColdFusion Server 5 to work together. I have a ColdFusion server that connects to MySQL via ODBC. I've configured the Merant MySQL ODBC driver via the ColdFusion administrator, and it is able to connect to my MySQL database (at least it claims that the connection was successful when clicking "verify" in the CF admin). The datasource name is hpTest. However, trying to connect to the database in an CFM doesn't seem to work at all. My error message is "ODBC Error Code = 08003 (Connection not open) "[MERANT][ODBC lib] Connection not open "The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:114)." and the code goes like this: <cfquery name="Test" dbtype="ODBC" dbname="hpTest" datasource="hpTest"> SELECT * FROM hpTest </cfquery> <cfoutput query="hpTest">#FieldName1#, #FieldName2#<br></cfoutput> I've been reading TFM, browsing TFW, reading TFML and I've even been to (*ghasp*) Microsofts ODBC-pages looking for an answer (and you know it's -bad- when that happens!<g>). Reading the manual I got the impression that coldfusion would open the connection when using a <cfquery>-tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php