SQL Server Performance

third party tool

Discussion in 'Third Party Tools' started by deepbluec, Nov 21, 2003.

  1. deepbluec New Member

    Hi all,

    Does anyone know how or whether there are third party tools that allow communication between IBM and SQL Server and vice versa? If you know, please advise. Thank you.
  2. Luis Martin Moderator

    Would you explain what software from IBM do you want to connect?


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. bradmcgehee New Member

    Without knowing more, we use IBM's DBConnect server to connect our SQL Servers and our IBM mainframe. Using DBConnect, we can then use DTS, or code, to communicate between them.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  4. satya Moderator

    I think Client Access Driver is used to connect SQL server from DB2.
    You would get more information from IBM site for details.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. deepbluec New Member

    quote:Originally posted by LuisMartin

    Would you explain what software from IBM do you want to connect?


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell


    Hello,
    Thanks for replying. I want something that communicates with Unix and SQL Server
    and vice versa. Any idea?
  6. FrankKalis Moderator

    http://www.unixodbc.com/ might be a first step. There are other around.

    Basically you can also have something like a shared directory and something like samba, output your data to files on that directory and pull with with DTS into SQL Server.

    Frank
    http://www.insidesql.de
    http://www.familienzirkus.de
  7. satya Moderator

    MS doesn't have any such facility from db-library, odbc, oledb for SQL server and I believe using following approach you can try:

    Use TDS 4.2 which shared with sybase and comply application to connect with this protocol.
    Third party tools like MERANT using ODBC, OPENLINK and its drivers, I think weblogic server and jdbc drivers also may help.
    Configure web appl. to access SQL and make unix client to connect to web box.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page