From ColdFusion if we need to connect to any database then we need to create datasource in ColdFusion administrator. In ColdFusion 8 administrator we have a database connection driver for “SQL server”. Before creating datasource we would need to check the Service Pack for SQL 2000. In order to successfully create the datasource for SQL 2000 with ColdFusion 8, SQL 2000 must have Service Pack 3 or above.
If we have SQL 2000 with Service Pack 2 then we need to do the following steps before creating datasource.
1. Download “Service Pack 3” for SQL 2000
2. Install SQL 2000 Service Pack 3
Then we need to follow the following steps to create Data Source in ColdFusion server administrator.
Login to ColdFusion administrator
Select Data & Services > Data Source
Enter Data Source Name
Select “Microsoft SQL Server” from the Driver dropdown
Enter Database name for which you want to create datasource
Provide IP address/Server Name for SQL 2000 server
By default the port will be “1433”
Provide the username and password for SQL 2000 database authentication