I know nothing of Linux, sorry. The dynamic dbtype is an ODBC DSNLess string, and I don't know if that is even possible on a Linux machine. Maybe someone else can enlighten us.
tom "Erik Retz" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Tom, > > Thank you. It works fine with CF 5 for windows, but not on linux. > > The following works on windows: > > <CFQUERY NAME="test" > DBTYPE="dynamic" > CONNECTSTRING="driver= > {mysql};database=sw;server=209.206.185.132;uid=username;pwd=password;option > =16386;"> > SELECT id from stores > </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists