karlpox | with GOD all things are possible |
Well these is a sample project for inserting/selecting/updating/deleting data from the database(MS SQL Server 2000) using ColdFusion.
The zzz datasource uses the SchDb database in the MS SQL Server 2000. You just need to define the datasource in the ColdFusion administrator to enable it.
If you just did a fresh install of Adobe ColdFusion 8 and Microsoft SQL Server 2000 and you tried to add a datasource but all you get is error. Its all because of the default MS SQL Server 2000 port which is 1433 is not a secure port in Windows XP.
To solve this problem you need to install the MS SQL Server 2000 SP4. This update will let Windows XP recognize the port 1433 as a secure port and will now let you connect your CFM datasource with MS SQL Server 2000.
Here`s a sample on how to update the database using Coldfusion.
Heres a sample on how to insert data into the database using CFM.
