ColdFusion 10 does not allow Access datasource

[hofar...@houseoffusion.com]

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

[hofar...@houseoffusion.com]

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

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358437

[hofar...@houseoffusion.com]

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.

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358438

[hofar...@houseoffusion.com]

>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

[hofar...@houseoffusion.com]

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

[hofar...@houseoffusion.com]

>>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

[hofar...@houseoffusion.com]

then you must have set them up manually using the workaround, as there is
no 64bit driver for windows.

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358442

[hofar...@houseoffusion.com]

>>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

[hofar...@houseoffusion.com]

>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

[hofar...@houseoffusion.com]

> 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

[hofar...@houseoffusion.com]

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

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358446

[hofar...@houseoffusion.com]

> 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

[hofar...@houseoffusion.com]

>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

[hofar...@houseoffusion.com]

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

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358449

[hofar...@houseoffusion.com]

>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

[hofar...@houseoffusion.com]

> > 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

[hofar...@houseoffusion.com]

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

[hofar...@houseoffusion.com]

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

[hofar...@houseoffusion.com]

>>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

[hofar...@houseoffusion.com]

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

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358476

[hofar...@houseoffusion.com]

>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

[hofar...@houseoffusion.com]

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

[hofar...@houseoffusion.com]

> 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

[hofar...@houseoffusion.com]

not the first time they have done that either, had the same issue with a
previous version of cf as well.

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358670