ColdFusion 9's ODBC Socket Datasource issue on Tomcat 7
Recently, I installed CF9 web app on Tomcat 7 build 22. I get the CF9 server up running fine on Tomcat 7. Everything works flawlessly, except one thing I really need, failed badly (see below please):
What I installed:
Installed CF9 with WAR selection and all sub-components checked on Win 7 32bit.
Installed CF9 update to 9.0.1
Deployed CF9.WAR on Tomcat 7 without an issue.
From CF Admin Manager, adding MS SQL Server without an issue. Also adding another Embedded Derby server fine.
The issue occurs when adding a data source for ODBC Socket type. The error messages are:
Error accessing available odbc datasource - Unable to load library The ColdFusion ODBC Server service is not running or has not been installed
I tried reinstalling CF9 again 2 times just to make sure everything was selected properly but NO luck. Same issue with ODBC Socket data source.
From Component Service Manager, CF9 ODBC Server is running, but there is no 'CF9 ODBC Agent' listed.
There is no way I could get CF9 ODBC data source on Tomcat.
Now, to make it works, I have to install and deploy CF9 on IIS 7.5 server on the same machine. The difference is both CF9 ODBC Server and Agent appearing and running on Service manager.
One more test:
And now I decided to stop IIS server and CF9 on IIS. I then started CF9 on Tomcat, everything works fine except for the same ODBC Socket datasource issue. What I noticed is the "CF9 ODBC Agent" disappeared from Service Manager.
The result is both CF9 on Tomcat AND CF9 on IIS now have same ODBC Socket data source issue. (Due to the disappearance of ODBC Agent)
To get CF9 ODBC data source back running on IIS server, I have uninstalled CF9 from IIS server, then reinstalled CF9 on IIS server. Now, it is working again, I can see both CF9 ODBC Server and Agent listed and running on Service manager.
My goal is to try to get CF9 on Tomcat 7 along with ODBC data source functioning. But NO LUCK so far.
Please HELP:
If anyone has CF9 deployed on Tomcat, please do me a favor by just entering any ODBC data source name with ODBC socket selection and HIT 'ADD' to see if it works. I doubt it would not work, because I have tried on the other machine at home. STILL NO LUCK :(.
If no one else can get it to work on Tomcat, then it is an Adobe CF9 issue and should be either handled in the next HOTFIX or in the next version release.
Please help me check for this issue.
Thank you & have a nice weekend.
Ben Nguyen
这似乎是你偶然发现的错误：http://www.elliottsprehn.com/cfbugs/bugs/79023
链接地址: http://www.djcxy.com/p/31236.html上一篇: CFTHREAD CFHTTP超时