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.  Connecting to SQL Server 2000 & 2005 at the same time

    Posted 09/24/08 12:44 AM

    I have two source database systems… One is on SQLServer2000 and other is on SQLServer2005.

    Can we connections to the two database versions from one IS at the same time?
    If so, Can we place two different drivers/jar files (One for SQL Server2000 and other for SQL Server2005) in the lib/jars folder?

    Thanks you
    Ravi


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


  • 2.  RE: Connecting to SQL Server 2000 & 2005 at the same time

    Posted 10/06/08 05:26 PM

    yes, you can do that but not sure if supported by webMethods. Make sure you get confirmation from them before doing that or else you will be on your own.


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


  • 3.  RE: Connecting to SQL Server 2000 & 2005 at the same time

    Posted 10/31/08 05:27 AM

    Thanks for the reply.

    Got it resolved…
    SQL Server 2005 drivers from microsoft worked for both 2000 & 2005.


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


  • 4.  RE: Connecting to SQL Server 2000 & 2005 at the same time