Skip to main content
D
dtharpe1
Participant
August 4, 2010
Question

The ColdFusion ODBC Server service has not been installed, HELP!

  • August 4, 2010
  • 1 reply
  • 1044 views

My applications are crashing because recently we rebuilt our server and coldfusion will not install the ODBC server srvice that I need for our access databases. I can still use the Access with Unicode driver but my applications are crashing where there is a text input field and more that 255 characters is being entered. The field is of 'memo' value already in access which is sussposed to support up to 65,000 characters. Does anyone know how to install this because I have reinstalled CF 8 like 3 times on our server adn the only answer I have found to fixing my errors is taht the Unicode driver is crashing them but I cnat use regular access driver because the ODBC service wont install. Please help adn dont ever use access db if you dont have to.

Thanks,

This topic has been closed for replies.

1 reply

J
JR__Bob__Dobbs
Inspiring
August 4, 2010

This might help.

http://go.adobe.com/kb/ts_kb402637_en-us

D
dtharpe1Author
Participant
August 5, 2010

Thanks for the quick reply but I vae already tried that. Im just wondering whyt Coldfusion isnt installing this much needed feature anyway. I mean this is crazy. Anyway thanks for your help

D
dtharpe1Author
Participant
August 10, 2010

It worked finally, got it to work. This link is what worked for me but I couldnt get it ot work before. http://kb2.adobe.com/cps/402/kb402637.html

So i exchange the datasource.cfc files like it says then I just put the installODBC.cfm in the CFIDE folder and went to http://myserver/CFIDE/installODBC.cfm and ran the application but had abother problem with authentication ,"the user does not have permission" so I opeened the installODBC.cfm in an editor and noticed that the line said,     adminObj.login("admin"); which wanted a default password for the system setup but if you have your own password setup for security reasons (which you should) it wont run. So go into you CFAdmin, then go to Security > Administrator > then select no authentication needed the try to reload the installODBC.cfm page and it will execute and say that "ODBC Services installed". Then change back to having a single password needed.

Good Luck if you ever have this stupid problem...

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