I created a simple BMP Entity Bean that connects to MS Sql Server 2000. I use JBoss 3.2.5 as my Application Server. I always get this error, "No suitable driver". I know that my jboss is not yet configured with ms sql server 2000. Can somebody provide me the steps in configure jboss 3.2.5 with ms sql server 2000?
Create a DataSource - this will be a file, something like mssql-ds.xml - and put it in your deploy directory. You should be able to find examples of *-ds.xml files in the examples that ship with JBoss.
Find a suitable driver for MSSQL. You could use Microsoft's own, but its not very good. Better is jTDS. Read the driver documentation, which will tell you where to put what.
Make sure you SQL server instance is configured correctly - SQL Server and Windows authentication etc. (you can find stuff on MSDN about this if you don't know)
And there you go. When you start JBos;s, assuming you have done everything correctly, there should be a DataSource avaliable through JNDI.