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
Back to discussions
Expand all | Collapse all

JDBC adapter for SQL server 2000 (Driver 3.0 version)

  • 1.  JDBC adapter for SQL server 2000 (Driver 3.0 version)

    Posted Fri July 30, 2010 10:02 PM

    Hi Guys,

    Hmm this information is not in webMethods documentation so was wondering to share to you folks, the datasource class name should be used to connect to MS SQL Server 2000 with microsoft jdbc driver version 3.0 as 2.x is not available for downloading from MS site.

    Datasource Class name : com.microsoft.sqlserver.jdbc.SQLServerDataSource.

    Specially if you working on Wm 8.x, JVM 1.6 does not support sqljdbc.jar driver and ask for JDBC driver type 4, so please use sqljdbc4.jar.

    Note: Place sqljdbc4.jar in IS/lib/jars direcotry.

    cheers!
    nD


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


  • 2.  RE: JDBC adapter for SQL server 2000 (Driver 3.0 version)

    Posted Mon August 02, 2010 11:02 AM

    Hi Devexpert,

    Yes, you are right, am also using wM8 version , four months back i got problem using sqljdbc.jar, i got error message that JVM 1.6 doesnot support sqljdbc.jar SQL Server 2000 with microsoft jdbc driver , than i used sqljdbc4.jar, than it is supporting.

    Regards,
    Anil Kumar ellendula


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


Related Content