Any IIS / Apache rewrite rules involved here?
No rewrite rule involved here
Apache is working fine ..we have tested with index page. and can able to view content under document directory.
i have noticed ODBC service is down and seeing below error ..Is this causing the issue?
The description for Event ID 0 from source ColdFusion 9 ODBC Agent cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
Did you check your code for cflocation, cfheader and other redirects? ODBC doesn't sound like a too many redirects error.