Re: ColdFusion 10 does not allow Access datasource
not the first time they have done that either, had the same issue with a previous version of cf as well. On Tue, May 20, 2014 at 5:52 PM, Leith Tussing wrote: > > > I'm running into issues with this and the new CF11. The same server > > has CF9 on it and it's a Windows 2008 R2 system so I had already > > worked though getting the Access files working in a 64bit environment > > by using the 32bit ODBC to add them before adding them in CF. > > > > However now in CF11 when I try to add them I always get the "The > > ColdFusion ODBC Server service is not running or has not been > > installed. You may also use the 'MS Access with Unicode' driver to > > connect to MS Access datasources." error. So I went through all the > > suggestions found here and none of them have worked. I checked the > > ODBC Server & Agent services exist and are running. There are no > > system log or CF log entries from them. I shut down the CF9 ODBC > > services just in case they were conflicting then restarted CF11. I > > deleted the trace files. > > > > I can successfully add and use MS-SQL datasources though. > > It turns out my issue is actually a bug in CF11. > > https://bugbase.adobe.com/index.cfm?event=bug&id=3759846 > > If you had CF10 installed then install CF11 the system will only use the > CF10 ODBC services and not the CF11 ones. We had installed CF10 but it's > disabled now. > > ~| 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:358670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
> I'm running into issues with this and the new CF11. The same server > has CF9 on it and it's a Windows 2008 R2 system so I had already > worked though getting the Access files working in a 64bit environment > by using the 32bit ODBC to add them before adding them in CF. > > However now in CF11 when I try to add them I always get the "The > ColdFusion ODBC Server service is not running or has not been > installed. You may also use the 'MS Access with Unicode' driver to > connect to MS Access datasources." error. So I went through all the > suggestions found here and none of them have worked. I checked the > ODBC Server & Agent services exist and are running. There are no > system log or CF log entries from them. I shut down the CF9 ODBC > services just in case they were conflicting then restarted CF11. I > deleted the trace files. > > I can successfully add and use MS-SQL datasources though. It turns out my issue is actually a bug in CF11. https://bugbase.adobe.com/index.cfm?event=bug&id=3759846 If you had CF10 installed then install CF11 the system will only use the CF10 ODBC services and not the CF11 ones. We had installed CF10 but it's disabled now. ~| 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:358669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
I'm running into issues with this and the new CF11. The same server has CF9 on it and it's a Windows 2008 R2 system so I had already worked though getting the Access files working in a 64bit environment by using the 32bit ODBC to add them before adding them in CF. However now in CF11 when I try to add them I always get the "The ColdFusion ODBC Server service is not running or has not been installed. You may also use the 'MS Access with Unicode' driver to connect to MS Access datasources." error. So I went through all the suggestions found here and none of them have worked. I checked the ODBC Server & Agent services exist and are running. There are no system log or CF log entries from them. I shut down the CF9 ODBC services just in case they were conflicting then restarted CF11. I deleted the trace files. I can successfully add and use MS-SQL datasources though. ~| 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:358668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>Have you rebooted again just to make sure that it doesn't happen again, I >only mention this because that was what you said caused it. Just looking at >making sure this is a 100% fix. Yes, I have rebooted once so far. And tomorrow I'll probably get my courage up to apply those updates that were not in the download. And each time I do something I will check carefully in case that is what caused the failure. Thanx for all your help and feedback. ~| 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:358477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
John, Have you rebooted again just to make sure that it doesn't happen again, I only mention this because that was what you said caused it. Just looking at making sure this is a 100% fix. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Apr 30, 2014 at 6:00 AM, John Pullam wrote: > > At the moment I have the Access datasources working. Here is what solved > it for me: > > The underlying issue was that message that said "The ColdFusion ODBC > Server service is not running or has not been installed." I observed the > behaviour of the ODBC server and realized that it was running fine after an > install (I redid the CF10 instrall) but it was the next reboot that caused > things to stop working. > > I located an error message in the log that said "ColdFusion 10 ODBC > Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace > file because the file version is not recognised." And when I googled that > one I ran into a similar problem on CF9 where the person reporting it said > "I have solved this problem by deleting all of the .trc files in folder > C:\ColdFusion9\db\slserver54\tracing. Once that was done, I was able to > successfully start the ODBC Server & ODBC Agent services." > > After deleting the .trc files from > C:\ColdFusion10\cfusion\db\slserver54\tracing I was able to start the > services manually. I then rebooted and it worked. I am not sure that this > is a long term fix but it is working. I notice that the 2 .trc files are > back in that folder and hope thay are correct now. > > And of course I had to also use that workaround mentioned 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:358476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>>Here is what solved it for me: I'm glad you could work it out. The more we go and the more we are having issues harder and harder to solve :-( ~| 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:358470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
At the moment I have the Access datasources working. Here is what solved it for me: The underlying issue was that message that said "The ColdFusion ODBC Server service is not running or has not been installed." I observed the behaviour of the ODBC server and realized that it was running fine after an install (I redid the CF10 instrall) but it was the next reboot that caused things to stop working. I located an error message in the log that said "ColdFusion 10 ODBC Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace file because the file version is not recognised." And when I googled that one I ran into a similar problem on CF9 where the person reporting it said "I have solved this problem by deleting all of the .trc files in folder C:\ColdFusion9\db\slserver54\tracing. Once that was done, I was able to successfully start the ODBC Server & ODBC Agent services." After deleting the .trc files from C:\ColdFusion10\cfusion\db\slserver54\tracing I was able to start the services manually. I then rebooted and it worked. I am not sure that this is a long term fix but it is working. I notice that the 2 .trc files are back in that folder and hope thay are correct now. And of course I had to also use that workaround mentioned 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:358469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
John, The behavior you are describing with the ODBC service does not sound normal. Have you looked around in the Windows event viewer to see if there are any error messages related to the ColdFusion ODBC Service? Isn't there also a second ODBC-related service for ColdFusion? Is that one running? They both may need to be reinstalled. -Carl V. On 4/28/2014 12:58 PM, John Pullam wrote: > I went into Services and the ODBC service is defined and it set up as > automatic. When I started it, it said it started and then stopped. It > indicated that some services only start when they are needed. I then > made it manual and started it again and received the same message. So > I think that it believes it is there and is able to run. ~| 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:358452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
> > Is the service running? > > I went into Services and the ODBC service is defined and it set up as > automatic. When I started it, it said it started > and then stopped. It indicated that some services only start when they are > needed. I then made it manual and > started it again and received the same message. > > So I think that it believes it is there and is able to run. No, if it's not running, it's not able to run. Windows doesn't really know why services stop or start. Search "coldfusion odbc server service is not running" for possible solutions. > > You may also use the "MS Access with Unicode" driver to connect to > > MS Access datasources." > > > > Have you tried this? > > There is no entry for that driver in the drop-down for CF10. It seems to have > disappeared after CF9. It turns out you only get this if you install on a 32-bit OS. You might find this useful: http://forums.adobe.com/thread/1225802?tstart=0 Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:358451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>As with anything it is a process of elimination, what about the other >suggestion it says. I don't recall if you tried that or not. The other suggestion was the Microsoft Access driver with Unicode. There is no such driver being offered in the driver list (there was in CF9 but it is no longer there in CF10). ~| 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:358450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
As with anything it is a process of elimination, what about the other suggestion it says. I don't recall if you tried that or not. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Tue, Apr 29, 2014 at 6:02 AM, John Pullam wrote: > > >This is going to sound a bit basic, but did you actually install the ODBC > >drivers when you installed ColdFusion? > > I have no problem with suggesting basic stuff ... I make errors like > everyone else. But the fact that the ColdFusion 10 ODBC Server is in > Services should suggest that it is actually there. > > > >Just out of curiosity, I know you mentioned the reason behind this in > >another thread, but is there any chance that this maybe the time to just > >bite the bullet and export the data into a SQL DB? > > My application receives its Access databases from an external 3rd party > application which I cannot change. I can't think of any practical way to > avoid using them. > > ~| 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:358449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>This is going to sound a bit basic, but did you actually install the ODBC >drivers when you installed ColdFusion? I have no problem with suggesting basic stuff ... I make errors like everyone else. But the fact that the ColdFusion 10 ODBC Server is in Services should suggest that it is actually there. >Just out of curiosity, I know you mentioned the reason behind this in >another thread, but is there any chance that this maybe the time to just >bite the bullet and export the data into a SQL DB? My application receives its Access databases from an external 3rd party application which I cannot change. I can't think of any practical way to avoid using them. ~| 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:358448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
> Is the service running? I went into Services and the ODBC service is defined and it set up as automatic. When I started it, it said it started and then stopped. It indicated that some services only start when they are needed. I then made it manual and started it again and received the same message. So I think that it believes it is there and is able to run. > > You may also use the "MS Access with Unicode" driver to connect to > MS Access datasources." > > Have you tried this? There is no entry for that driver in the drop-down for CF10. It seems to have disappeared after CF9. ~| 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:358447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
John, I am going to focus on your actual error message. *The ColdFusion ODBC Server service is not running or has not been installed. You may also use the "MS Access with Unicode" driver to connect to MS Access datasources.* This is going to sound a bit basic, but did you actually install the ODBC drivers when you installed ColdFusion? I have not used Access since 1995, so I am only gasping at the hope that is what maybe the problem. Just out of curiosity, I know you mentioned the reason behind this in another thread, but is there any chance that this maybe the time to just bite the bullet and export the data into a SQL DB? Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Tue, Apr 29, 2014 at 5:33 AM, John Pullam wrote: > > >Are you able to manually create a 32-bit ODBC connection to your Access > >database? If you weren't aware already, you need to run the 32-bit > >Windows ODBC data sources applet from inside \Windows\SysWOW64 to access > >the 32-bit stuff. If you can do that successfully, then try connecting > >to that 32-bit ODBC data source from within CF Administrator. > > If you mean can I run C:\Windows\SYSWOW64\odbcad32.exe, the answer is yes. > It allows me to select an Access datasource and to specify the mdb file. > But when I go back into the CF administrator I again get that error message > when I try an add of a Microsoft Access > file. > > You said that I should try connecting it with the administrator. Does that > mean something other than trying to add it as I have done? > > I'm still unable to get past that error "The ColdFusion ODBC Server > service is not running or has not been installed. You may also use the "MS > Access with Unicode" driver to connect to MS Access datasources." > > Any ideas would be appreciated... > > ~| 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:358446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
> I'm still unable to get past that error "The ColdFusion ODBC Server service > is not running or has not been > installed. Is the service running? > You may also use the "MS Access with Unicode" driver to connect to MS Access > datasources." Have you tried this? Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:358445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>Are you able to manually create a 32-bit ODBC connection to your Access >database? If you weren't aware already, you need to run the 32-bit >Windows ODBC data sources applet from inside \Windows\SysWOW64 to access >the 32-bit stuff. If you can do that successfully, then try connecting >to that 32-bit ODBC data source from within CF Administrator. If you mean can I run C:\Windows\SYSWOW64\odbcad32.exe, the answer is yes. It allows me to select an Access datasource and to specify the mdb file. But when I go back into the CF administrator I again get that error message when I try an add of a Microsoft Access file. You said that I should try connecting it with the administrator. Does that mean something other than trying to add it as I have done? I'm still unable to get past that error "The ColdFusion ODBC Server service is not running or has not been installed. You may also use the "MS Access with Unicode" driver to connect to MS Access datasources." Any ideas would be appreciated... ~| 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:358444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>>then you must have set them up manually using the workaround. Yes, I think so, it was a long time ago. ~| 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:358443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
then you must have set them up manually using the workaround, as there is no 64bit driver for windows. On Mon, Apr 28, 2014 at 4:37 PM, <> wrote: > > >>This also means you will have hosting problems, as Windows is 64bit only > since Server 2008, so you wont be able to setup a CF DSN unless the host is > willing to also do this workaround for you or unless they are still running > Windows 2003. > > Actually, I do have Access databases on my Window Web server 2008 R2 using > the 32bit ODBC and CF9. > So may be the problem is specific to CF10? > > > ~| 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:358442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>>This also means you will have hosting problems, as Windows is 64bit only since Server 2008, so you wont be able to setup a CF DSN unless the host is willing to also do this workaround for you or unless they are still running Windows 2003. Actually, I do have Access databases on my Window Web server 2008 R2 using the 32bit ODBC and CF9. So may be the problem is specific to CF10? ~| 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:358441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
John, Are you able to manually create a 32-bit ODBC connection to your Access database? If you weren't aware already, you need to run the 32-bit Windows ODBC data sources applet from inside \Windows\SysWOW64 to access the 32-bit stuff. If you can do that successfully, then try connecting to that 32-bit ODBC data source from within CF Administrator. HTH, -Carl V. ~| 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:358440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
>The only option is to use the workarounds to get a 32bit ODBC DSN setup. >This also means you will have hosting problems, as Windows is 64bit only >since Server 2008, so you wont be able to setup a CF DSN unless the host is >willing to also do this workaround for you or unless they are still running >Windows 2003. Actually I have read and tried this very workaround. And being on my desktop, I don't have a hoster to worry about at the moment. But when I click on Add (step 3 in that article), I get the above message. So I can't even get into the workaround any more. (It seemed to work at first but stopped after some updates and a reboot.) ~| 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:358439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
You could also use a Java driver to communicate with Access http://www.hxtt.com/access.html. I use this driver on my Mac to work on some older sites that I have to support and are using Access. On Mon, Apr 28, 2014 at 10:10 AM, Russ Michaels wrote: > > The problem is not just with CF. If you are using a 64 bit edition of > windows, then the Jet driver is no longer supported by Microsoft and > doesn't work on modern 64bit OS. > The only option is to use the workarounds to get a 32bit ODBC DSN setup. > This also means you will have hosting problems, as Windows is 64bit only > since Server 2008, so you wont be able to setup a CF DSN unless the host is > willing to also do this workaround for you or unless they are still running > Windows 2003. > > See this: > http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess > > > > > On Mon, Apr 28, 2014 at 2:57 PM, John Pullam >wrote: > > > > > I have a newly installed CF10 system working on my desktop (developer) > > machine, including several working SQL Server datasources. But when I try > > to get the Access ones to work I keep running into issues. > > > > I installed the 32 bit version of ColdFusion in order to bypass the > issues > > with 64 bit drivers, but the results I get sound similar to what others > > have said already. Unfortunately the suggestions and fixes in those > > postings don't seem to help in my case. Initially I thought I had this > > working but after a reboot, its behaviour changed and the Access > > datasources failed, so I deleted them in order to try again. > > > > Now, when I attempt to add a new datasource, I get the message "The > > ColdFusion ODBC Server service is not running or has not been installed. > > You may also use the "MS Access with Unicode" driver to connect to MS > > Access datasources." > > > > I did the obvious things such as going into services and manually > starting > > the service. Also there is no Unicode driver option in the administrator. > > > > Any ideas? > > > > > > ~| 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:358438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
The problem is not just with CF. If you are using a 64 bit edition of windows, then the Jet driver is no longer supported by Microsoft and doesn't work on modern 64bit OS. The only option is to use the workarounds to get a 32bit ODBC DSN setup. This also means you will have hosting problems, as Windows is 64bit only since Server 2008, so you wont be able to setup a CF DSN unless the host is willing to also do this workaround for you or unless they are still running Windows 2003. See this: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess On Mon, Apr 28, 2014 at 2:57 PM, John Pullam wrote: > > I have a newly installed CF10 system working on my desktop (developer) > machine, including several working SQL Server datasources. But when I try > to get the Access ones to work I keep running into issues. > > I installed the 32 bit version of ColdFusion in order to bypass the issues > with 64 bit drivers, but the results I get sound similar to what others > have said already. Unfortunately the suggestions and fixes in those > postings don't seem to help in my case. Initially I thought I had this > working but after a reboot, its behaviour changed and the Access > datasources failed, so I deleted them in order to try again. > > Now, when I attempt to add a new datasource, I get the message "The > ColdFusion ODBC Server service is not running or has not been installed. > You may also use the "MS Access with Unicode" driver to connect to MS > Access datasources." > > I did the obvious things such as going into services and manually starting > the service. Also there is no Unicode driver option in the administrator. > > Any ideas? > > ~| 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:358437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 10 does not allow Access datasource
I have a newly installed CF10 system working on my desktop (developer) machine, including several working SQL Server datasources. But when I try to get the Access ones to work I keep running into issues. I installed the 32 bit version of ColdFusion in order to bypass the issues with 64 bit drivers, but the results I get sound similar to what others have said already. Unfortunately the suggestions and fixes in those postings don't seem to help in my case. Initially I thought I had this working but after a reboot, its behaviour changed and the Access datasources failed, so I deleted them in order to try again. Now, when I attempt to add a new datasource, I get the message "The ColdFusion ODBC Server service is not running or has not been installed. You may also use the "MS Access with Unicode" driver to connect to MS Access datasources." I did the obvious things such as going into services and manually starting the service. Also there is no Unicode driver option in the administrator. Any ideas? ~| 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:358436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
