When I tried to create a DSN, I received an error that the data source name is invalid. What did I do wrong? More than likely, you entered an invalid character in the name of your DSN. Make sure that your name contains only numbers and letters with no special characters such as ~ or _. In addition, the DSN cannot contain any spaces. My DSN used to say OK in the status field, but now nothing is displayed there. Is there a way to check the connection? Yes. Log in to the ColdFusion Administrator and choose Data Sources. In the Data Sources page, click the Verify All Connections button at the very bottom of the page. The status of the connections should return. |