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

Connecting SQL Server 2000 through JDBC Adapater

  • 1.  Connecting SQL Server 2000 through JDBC Adapater

    Posted Sat November 25, 2006 12:30 PM

    :confused:
    Hi everybody…
    i facing the problem while enabling the JDBC Adapater :which has
    the following connection properties
    i am using windows 2003 server OS
    Transaction type :Local
    Datasource Class:com.microsoft.jdbcx.sqlserver.SQLServerDataSource
    ServerName:192.168.0.51 (i tried with Name also “Webfmis2”)
    User :Sa
    password:sa
    password:sa
    databaseName:WMDB
    portNumber :1433
    networkProtocal:
    Other Properties:SelectMethod=cursor

    management properties
    True
    1
    10
    1000
    1000

    and i have copied Threee Jar files in ishome\lib\jars & F:\Program Files\webMethods6\IntegrationServer\packages\WmJDBCAdapter\code\jars folder also still i am facing a Error while enabling it .

    Error Name is :Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource FlowServices:MsSQLConncection.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.iaik.asn1.structures.NameCan anybody give the solutions for this problem…I tried a lot of combinations…but its not working…Thanks a lot…Plz let me know the solution for thisRegards


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


  • 2.  RE: Connecting SQL Server 2000 through JDBC Adapater

    Posted Tue February 06, 2007 06:28 AM

    Hi there!

    everything is perfect. I feel the server name what you have entered was the system URL. You should enter database server name there. Hope it will resolve the issue.

    regards,
    zakir


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