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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  Error connecting with sql server driver

    Posted 01/20/10 01:37 PM

    Hi,

    I get the following error when I try to test the JDBC driver for SQL Server 2000.

    Test of TN Failed
    [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

    I have checked all values a thousand times and everything seems correct. I dont know what else to try.

    Can someone help me?

    Thank you very much.


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


  • 2.  RE: Error connecting with sql server driver

    Posted 01/21/10 12:26 AM

    Internal pools uses DataDirect driver, the connection URL must be something like:

    Associated Driver Alias: DataDirect Connect JDBC SQL Server Driver
    Database URL: jdbc:wm:sqlserver://localhost:1433;databaseName=myDatabase

    From the error you have, looks like you have configured a native SQL server driver.

    Check your connection URL and Driver alias.


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


  • 3.  RE: Error connecting with sql server driver

    Posted 01/21/10 09:51 AM

    How can i check connection URL and Driver alias??

    The URL im using is:

    jdbc:microsoft:sqlserver://localhost:1433;databaseName=TNDB;SelectMethod=cursor;SendStringParametersAsUnicode=false


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


  • 4.  RE: Error connecting with sql server driver

    Posted 02/01/10 04:57 PM

    you should use BDataDirect Connect JDBC SQL Server Driver[/b] instead of BMicrosoft JDBC Driver [/b]

    [/b]


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