can not connect with SQL Server using JDBC

Discussions

EJB programming & troubleshooting: can not connect with SQL Server using JDBC

  1. can not connect with SQL Server using JDBC (1 messages)

    hi,all
       I want to connect with SQL Server using JDBC. I use weblogic 5.1, SQL Server 7.0,
     and after config the weblogic and install the JDBC Driver.
    Then I use in DOS prompt:
      java utils.dbping MSSQLSERVER4 zzz 999 AAA@CHEPM
    where CHEPM is the host name and AAA is the database name,zzz the user name,999 is password.
      It works OK!

    But when program try to fetch some data from database , it display following erro message.

    Pool connect failed: Connection Pool p2gPool does not exist. err occured is java.sql.SQLException: Pool connect failed: Connection Pool p2gPool does not exist.


    waiting for your help.thanks.
    zhoujy


  2. can not connect with SQL Server using JDBC[ Go to top ]

    have u created the connection pool. u have to do that in ur weblogic.properties file.