Ben, Moving from MS Access to MS SQL is one of the easiest options for migration I'm afraid.
FYI you CAN get Access running on 08r2 with CF 64bit. It just takes some work. -Mark -----Original Message----- From: Ben [mailto:b...@webworldinc.com] Sent: Tuesday, November 05, 2013 9:07 AM To: cf-talk Subject: Re: Problem with data formatting in CFINSERT Hi Russ For those of us who have been out of the loop for a while, can you suggest easy to implement alternatives to 32 bit MS access? I did a conversion of a DB to SQL server some years back and that was painful. Ben > On Nov 5, 2013, at 7:52 AM, Russ Michaels <r...@michaels.me.uk> wrote: > > > well someone has to say it... > but why the frack are you still using MSACCESS when there are so many > better/free alternatives? > you know the Jet driver (which is what you use to connect to MSACCESS) is > no longer supported by Microsoft and ha snot been for years and only runs > in 32 bit, and as such does not work on modern 64bit OS (without lots of > hacking to get it to run in 32bit mode), which is Windows Server 2008 > onwards, there is no 32 bit windows any more. > > > >> On Tue, Nov 5, 2013 at 2:44 PM, <> wrote: >> >> >>>> I have robot updaters and inserters too (made all the more robotic with >> the >> help of cfdbinfo figuring out the field types), >> >> This is what I do, but using my own CFX_ODBCinfo I developped years before >> cfdbinfo was available, >> and I'm still using it because cfdbinfo doesn't work for Access databases. >> >>>> Debugging is miserable with a layer of >> code in the middle and straightforward without. >> >> Right, I think I'm going to improve my CF_INSERT tag by generating the SQL >> code in the tag. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:357039 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
