webMethods

webMethods

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
  • 1.  Could not connect: No suitable driver

    Posted Wed March 28, 2007 06:56 AM

    Hi,

    Iam trying to connect to MS SQL Server 2000 from Business Connector

    I have copied the msbase.jar, mssqlserver.jar, msutil.jar files to
    sapbc/IS/lib/jars folder and

    the connection settings which i gave
    Alias: xyz(Interface name)
    DB URL: xyz:123.com
    DB Username: xyz
    DB Password: xyz
    DB Driver:
    Minimum Connections:
    Maximum Connections:
    Expiration Time (ms) :
    Loaded Drivers : (selected)
    after this submitted and i have restarted the dev server
    but still iam getting “Could not connect: No suitable driver” Error

    please suggest me what to do in this regard


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


  • 2.  RE: Could not connect: No suitable driver

    Posted Thu March 29, 2007 07:33 PM

    You need to enter the driver class name where it says DB Driver. For SQL Server 2000, it should be com.microsoft.jdbc.sqlserver.SQLServerDriver

    • Percio

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


  • 3.  RE: Could not connect: No suitable driver

    Posted Fri March 30, 2007 08:17 AM

    given the driver name but still getting the same error “Could not connect: No suitable driver”


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