Skip to main content
R
RLH_in_MD
Participant
November 16, 2011
Question

ColdFusion 8 ODBC agent service missing

  • November 16, 2011
  • 1 reply
  • 2311 views

I am in the process of rebuilding our server that is running ColdFusion.  I am having trouble getting the ODBC services to install and run properly which I need to be able to connect to some MS Access databases.

Configuration:

  • Microsoft Windows Server 2008 R2 64-bit
  • WebSphere 6.1
  • ColdFusion 8  (when installed shows as version 8,0,0,176276)

The installation of ColdFusion and deployment to WebSphere seemed to be ok.  CF seemed to be working until I tried configuring an MS Access database. What I found was:

  • "ColdFusion 8 ODBC Server" appeared in the services but would not start.
  • "ColdFusion 8 ODBC Agent" did not appear in the services.

I tried following the documented processes to manually remove and install the ODBC services, however when I run the install, I get HTTP 500 errors.  Digging deeper I found that the configuration files that I was supposed to copy in referenced locations that were not where CF was installed.  I made changes to those files to hopefully fix the problems.  Now when I run the install process, I note the following:

  • I still get HTTP 500 error when I run the install.
  • ColdFusion 8 ODBC Server appears in the services and now seems to start ok.
  • ColdFusion 8 ODBC Agent does not appear.
  • I can configure MS Access, but get these errors:
    • Unable to update the NT registry.
    • Unable to load library
  • The data source appears in the list of data sources but it does not work.

By the way, I originally installed the documentation with CF.

Does anyone have any ideas on what my problem might be?

This topic has been closed for replies.

1 reply

J
JR__Bob__Dobbs
Inspiring
November 16, 2011

This blog post may be helpful.

http://www.coldfusionmuse.com/index.cfm/2010/12/31/Access.on.64bit.ColdFusion

R
RLH_in_MDAuthor
Participant
November 16, 2011

Thanks Bob.  That site was indeed helpful.  It explained a lot of things very nicely.  However, I am still stuck.  I followed the instructions there and when I try to access the database in a test app, I get "SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.."

Note that I am still in a situation where I do not have a service with the name "ColdFusion 8 ODBC Agent".  Somehow I feel this is related to my impediment.

Thanks,

Dick Horner

D
Community Expert
Dave WattsCommunity Expert
Community Expert
November 25, 2011

You may need to reinstall SequeLink. There are a couple of more or less relevant technotes on the Adobe site, like this one:

http://kb2.adobe.com/cps/191/tn_19135.html

All that said, I would recommend you spend the time to migrate your databases from Access to ... something else. Almost anything else.

Dave Watts, CTO, Fig Leaf Software

Dave Watts, Eidolon LLC
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices