Russ, Thank you for the additional information.
Yes, a move away from MS Access needs to happen at some point. The customer just needs something working for right now. If the platform were migrated to SQL Server Express, I'm wondering if that would entail too many changes to my queries... Anyway, thanks again for the info. Best, Roberto At 06:46 AM 11/17/2011, Russ Michaels wrote: >the MSAccess with Unicode is not an ODBC driver that's why, so if you >can use this it would be better. it does have some differences so some >databases may cause error and need some fixing. >As for the ODBC service, check the runtime logs for more info >c:\coldfusion8\runtime\logs > > >To avoid all the MSAccess related headaches I would suggest you >install SQL Server 2008 Express which is free and use the upsize >wizard in Access or Microsofts free migration tools to migrate form >Access to SQL server, > > >On Thu, Nov 17, 2011 at 11:40 AM, Roberto Perez <r...@technologist.com> wrote: > > > > Russ, > > > > Yes, the CF install was 32-bit, and I used the 32-bit ODBC > > application at c:/Windows/SysWOW64/odbcad32.exe (the 64-bit ODBC > > application would only show SQL drivers). > > > > Still, it was working last week and now it stopped. No updates were > > installed on the server, not even the 8.1 CF update that is out there. > > > > Any ideas on the Microsoft Access with Unicode driver on the CF > > administrator? I noticed that to create a DSN entry with that driver, > > you do not need to create one in Windows at all. The CF > > administrator, if you use the "unicode" version of the driver, will > > ask you for the location of your database. Is this CF's way to handle > > the 32-bit / 64-bit driver issue? > > > > Thanks, > > > > Roberto > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
