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

[dtharpe1]

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,

[JR__Bob__Dobbs]

This might help.

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

[dtharpe1]

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

[dtharpe1]

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