Re: 32 vs 64 bit CF and DSNs
what you have suggested is a work around using 32bit, not native 64 bit. As I did mention there are work arounds , but they will not allow a CF DSN to just be setup in the CFADMIN with no other work, including your suggestion above, they require extra steps. I have yet to find a perfect solution that allows CF DSN's for MSACCESS to work with no other manual steps. If you know otherwise, please do share/ You find more info here. http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6 On Sun, Mar 10, 2013 at 2:06 AM, wrote: You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, Actually you can. Look for C:\Windows\SysWOW64\odbcad32.exe This is a 32bit ODBC Data source Administrator. Use it to define your System DSN first, then in the CF Administrator define your datasource with the Microsoft driver on that ODBC DSN. I have CF 9 32bit installed, because of some legacy CFX compiled in 32bit, and it works well. It might be slightly different with CF 64bits, then have a look here: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Creating a knowledge base
Hi, I am tasked with creating a knowledge base for our web application. I have been given lots of FAQs and wondering the best way to implement it. Would The best way be to use cfcollection or to build it natively using the database (add the FAQ data into a database and search as normal) I havent much experience with coldfusion collections but are they mainly used if the FAQs were in a bunch of documents? Thanks for any support and guidance. Best wishes, Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating a knowledge base
The first thing I'd do is make sure I'm not simply re-inventing the wheel. Have you checked to see if someone hasn't already done this sort of thing already as an OSS project? -- Aam On 10 March 2013 12:06, Richard White rich...@re-base.net wrote: Hi, I am tasked with creating a knowledge base for our web application. I have been given lots of FAQs and wondering the best way to implement it. Would The best way be to use cfcollection or to build it natively using the database (add the FAQ data into a database and search as normal) I havent much experience with coldfusion collections but are they mainly used if the FAQs were in a bunch of documents? Thanks for any support and guidance. Best wishes, Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm