On Tue, Jul 19, 2011 at 8:20 AM, Daniel Eng <[email protected]> wrote:
> I set all of my Datasources in my Windows ODBC Why are you using ODBC? > This is my CFML code: > <cfquery name="#queryname#" datasource="#dsname#" dbtype="odbc"> > Pretty sure you don't need to specify ODBC as the dbtype. I believe that's been pretty much deprecated other than using a type of "query" for query of queries. > Also when I click on 'Verify All Datasources", this is the error I get > Short answer is don't use ODBC. Use JDBC and set up these datasources in the OpenBD administrator. It's going to perform infinitely better. If there's some reason you *must* use ODBC we can try to sort it out, but you really shouldn't be using ODBC when you have a vastly better option available. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
