Weblogic with SQLserver

Discussions

EJB programming & troubleshooting: Weblogic with SQLserver

  1. Weblogic with SQLserver (2 messages)

    hi
     im facing a strange problem.I m designing a CMP bean I have successfully created the output jar file. I m using SQLserver as my backend. Operating system windows 98. The problem is When i m starting my weblogic server, it is saying login failed with user 'sa' -jdbcodbc exception.
    But the datasource is correct and i tested it. Infact, i could even log into sqlserver using this. I m attaching the properties file.
    weblogic.jdbc.connectionPool.ProdPool=\
           url=jdbc:odbc:prod,\
           driver=sun.jdbc.odbc.JdbcOdbcDriver,\
           loginDelaySecs=1,\
           initialCapacity=4,\
           maxCapacity=10,\
           capacityIncrement=2,\
           allowShrinking=true,\
           shrinkPeriodMins=15,\
           refreshMinutes=10,\
           testTable=Product,\
           props=user=sa;password=none;server=local
    Can u tell me what's the error

    regards
    sundar
  2. I guess mistake is in password.password is (blank) ,you change password as password= and try
  3. Weblogic with SQLserver[ Go to top ]

    Hello This is Harish

    in your property file fragment

    "props=user=sa;password=none;server=local "

    remove server=local

    it should be "props=user=sa;password=none"

    because while configuring DSN(data Source Name) you will be specifying the server to which it will be communicating