IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Error while enabling JDBC Adapter connection with SQL Server

  • 1.  Error while enabling JDBC Adapter connection with SQL Server

    Posted Wed October 04, 2006 02:54 AM

    Hi all,

         I am getting the following error while enabling an JDBC Adapter connection with SQL Server.
    

    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource rajesh:rajesh.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    iaik.asn1.structures.Name

    I am using wm6.0.1 with servicepack2 and OS winXPHome Edition with servicepack 4

    and the properties i have given for the connection are
    TransactionType:Local_Transaction
    DataSourceClass:com.microsoft.jdbcx.sqlserver.SQLServerDataSource
    ServerName:COMP
    user:sa
    password:******
    databasename:master
    portnumber:1433
    networkprotocol:TCP/IP
    OtherProperties:

    Thanks in advance


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: Error while enabling JDBC Adapter connection with SQL Server

    Posted Wed October 04, 2006 07:40 AM

    Rajesh,

    Have a look at the technical article below which summarises the steps involved. As a guess it could be that the networkprotocol field which you have “TCP/IP” in, should be left blank. Have a read through this TA anyway:

    http://advantage.webmethods.com/article/?id=1611991362

    James…


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB