Is there a guide somewhere to setup the DataSource? Do I select 'Other JDBC Driver' or 'Microsoft jTDS Driver'?
Need all the help I can get. Thanks! Daniel On Tue, Jul 19, 2011 at 11:30 PM, Matthew Woodward <[email protected]>wrote: > 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 > -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
