JDBC Connection

[Eric Wright <eric(dot)wright(at)shaw(dot)ca>]

Hello, 

I am having some trouble connecting to my postgres database. 
I have started off with a simple test class to make and test a connection. When I run the simple tester I am getting the following output:

    The connection failed.
    java.sql.SQLException: No suitable driver
     at java.sql.DriverManager.getConnection(DriverManager.java:532)
     at java.sql.DriverManager.getConnection(DriverManager.java:171)
     at app.dao.ConnectionTest.main(ConnectionTest.java:28)

From the following test class:

package app.dao;
import java.sql.*;

public class ConnectionTest {
 public static void main(String[] args) {
  String url    = "jdbc:postgres://192.168.1.101/asset";
  String user   = "asset$admin";
  String pwd    = "password";
  try {
   Class.forName("org.postgresql.Driver");
   Connection con = DriverManager.getConnection(url, user, pwd);
   if(!con.isClosed()){
    System.out.println("The connection succeeded");
    con.close();
   }
  }catch(Exception e){
   e.printStackTrace();
   System.out.println("The connection failed.");
  } 
 }
}


I have read the information at http://www.fankhausers.com/postgresql/jdbc/#nosuitabledriver
I am using Eclipse 3.0 and trying it run it in the debugger.
I am using postgresql 7.4, JDK 1.4, and pg74.214.jdbc3.jar

Any help that you can provide would be great. 

Thanks Eric W