ColdFusion MX 7 DSN

Dear friends,

I upgraded to CF MX 7 DSN. I know it now has an API to create DSN without needing all those dangerous tags.

But its not working here. I set up CF Admin password in HC Settings. What else do I need to do?

When I try to create a DSN connection as a webadmin in HC and I choose to create it in ColdFusion also, I get following error:

An unexpected error has occured
AddDSN
apagamx

Thanks,
Flavio

Make sure CF password is correct in HC Settings under Scripting Tab. If you are using Devnet edition of ColdfusionMX server, due to which HC adds the ODBC DSN in CFMX but the expected response from the server is tempered by this water mark


and because of this reason, HC considers it as an error. So in this case you should remove this watermark and check this article that explains either you need to run server in Developer¬s edition or purchase a Standard or Enterprise license of CFMX.

If problem is still there then follow these steps:

1- CF is enabled on Default Web Site & HC Administration Site in IIS
2- CF service is running
3- HC works locally as http://localhost:8077 .
4- CF Administration is working locally http://localhost:8077/dsn/regc.cfm
5- Add a DWORD Key Named "DebugDSN" at "HKEY_LOCAL_MACHINE\SOFTWARE\Advanced Communications\Nt Web Hosting Controller\General" and give it value 1.
6-. Now add CFMX DSN from the control panel. A log will be created at C:\Program Files\Advanced Communications\Hosting Controller\web\admin\Logs\HCDSN.csv".

Please send this HCDSN.csv file as attachment to support. That debugging information can help us a lot in locating your problem.