Image

Rational Web Developer 6.0 problems

I am trying to make my connection pool. Under Database Servers, I have made my connection and tested it successfully. I created the server, added my project to that server and added the datasource to the Web Deployment Descriptor. However, when I try to run my application, I get the following error:
[5/5/05 10:46:05:729 EDT] 0000002f WebApp A SRVE0180I: [cmo230] [/cmo230] [Servlet.LOG]: Error making pool: java.sql.SQLException: Cannot connect to database reason: java.sql.SQLException: [IBM][SQLServer JDBC Driver]Error establishing socket. Unknown host

For the host, first I tried entering the ip of the machine the database is on. Then I tried using the name of the machine. Both tests were successful but again when I try to run I get an error. Could it be the port # 1433? I am using the Websphere Connect JDBC Driver.

I don't know what else the problem could be....I have a ConnectionPool class which makes the pool and that is where I am getting the error. However, this exact application is running on an older version of WAS right now, and it uses the same code so I don't see the problem. Any suggestions are greatly appreciated.

Thanks!