1 person found this helpful
There is a facility in the ColdFusion Administrator to enable you to connect to your MS SQL database.
Thanks for the message and help,
Do you mean that developer can not use connection string to connect MS SQL server?
Developer needs request ColdFusion Administrator to make the connection and in my application that I can use application parameter to connect MS SQL Server database.
Thanks again for helping and information,
If you are asking whether you can create an ad-hoc database connection using a connection string inside of a .cfm or .cfc file, I think the answer is probably no. A datasource can be programmatically created using teh CF Administrator API, but that would require granting the developer the permissions to use the API.
The datasource connection configuration is behind the CF Administrator and the Administrator API by design for security.
Thanks a million for the information and help,