Jayadev ,
I think you need to configure a 'Datasource' for SQL server 2000 , so that you can use that for your entity bean's data access purpose .
If you are using Websphere 5.0 and WSAD 5.0 , there is no need to download any JDBC driver for that, the support is built in .
You can create the datasource by following steps :
1) If you are using WSAD , Open your server configuration .
2) Go to the "Data source" page.
3)
You should see a section for "Server Settings", under that there is a section for "JDBC provider list" .
You need to add a JDBC provider for MS SQL server 2000, if you don't see one present already in the list .
Step 1) Create JDBC provider for SQL server 2000
Click "Add" button next to the JDBC provider list ,it should pop up a Create JDBC provider page .For Data base type select "MS SQL Server"
for JDBC Driver type select "Microsoft JDBC driver for MS SQLServer 2000" .
Click Next , enter any name for JDBC provider "Sqlserver2000" and click finish .
Step 2) Create SQL server Data source using above JDBC provider :
Select the JDBC provider you have just selected in above step .
Click "Add" button next to the Data source list." Create Data source" pop up should appear .
In the Create a Data Source window, select Version 5.0 data source for the
type of data source and click Next.
Complete the Modify Data Source window :
Enter valid values for Name and JNDI name columns (JNDI name will specify in theEJB deployment descriptor to access the database).
Make sure that Datasource helper class name has value selected as "com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper"
Click Check box that Use this data source in container-managed persistence (CMP)is selected. This is required for EJB access to the database.
Click Next.
Step III )
In the Modify Resource Properties window, select the databaseName
property and change the value to your Database Name
Click Finish.
The data source is added to the list and displayed in the server configuration
Save the server configuration and close the editor
You can then use the datasource created in EJB's .
I hope this helps ,
Thanks ,
Nikhil
P.S: I haven't used MS - SQL 2000 with Websphere yet ,above setps are listed based on the my experience on configuring datasources for other databases.
