DB2 and sql server 7 database connectivity


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: DB2 and sql server 7 database connectivity

  1. #1
    shank Guest

    DB2 and sql server 7 database connectivity


    we have db2 installed on OS/390 and sql 7 on NT. We require to retrive data
    from db2 databse from sql/NT environment ?
    Where can I find information on this such as odbc drivers etc. ?
    can someone help on this ?

    Thanks in advance.
    shanker



  2. #2
    Mark Guest

    Re: DB2 and sql server 7 database connectivity


    There a few ways to go. If you wish to access the database directly from
    NT you will need something like DB2Direct. You also could provide the data
    using web services or MQSeries. It depends on what your application is trying
    to, what currently exists and what you are willing to deal with.

    Mark

    "shank" <msrao999@yahoo.com> wrote:
    >
    >we have db2 installed on OS/390 and sql 7 on NT. We require to retrive data
    >from db2 databse from sql/NT environment ?
    >Where can I find information on this such as odbc drivers etc. ?
    >can someone help on this ?
    >
    >Thanks in advance.
    >shanker
    >
    >



  3. #3
    ElGalin Guest

    Re: DB2 and sql server 7 database connectivity


    The product you need is 'IBM DB2 Connect'

    regards,

    ElGalin

    "Mark" <mknuttall@nospam.com> wrote:
    >
    >There a few ways to go. If you wish to access the database directly from
    >NT you will need something like DB2Direct. You also could provide the data
    >using web services or MQSeries. It depends on what your application is

    trying
    >to, what currently exists and what you are willing to deal with.
    >
    >Mark
    >
    >"shank" <msrao999@yahoo.com> wrote:
    >>
    >>we have db2 installed on OS/390 and sql 7 on NT. We require to retrive

    data
    >>from db2 databse from sql/NT environment ?
    >>Where can I find information on this such as odbc drivers etc. ?
    >>can someone help on this ?
    >>
    >>Thanks in advance.
    >>shanker
    >>
    >>

    >



  4. #4
    Sharon Guest

    Re: DB2 and sql server 7 database connectivity


    We have been able to retrieve data from an AS400 using ClientAccess and SQL
    7. We have an NT server with IBM's ClientAccess and Microsoft SQL Server
    7 loaded. (The ClientAccess is needed to install the correct odbc or ole
    db drivers needed by MS SQL server). Once ClientAccess was installed, we
    created a DSN (data source name) from the Control panel in NT which set up
    the link. Next we created DTS packages to retrieve data but we could also
    create queries in SQL server or Microsoft Access to retrieve information.
    All this is assuming you've been given permissions, access, etc. to the
    AS400 data.

    Hope this helps...

    "shank" <msrao999@yahoo.com> wrote:
    >
    >we have db2 installed on OS/390 and sql 7 on NT. We require to retrive data
    >from db2 databse from sql/NT environment ?
    >Where can I find information on this such as odbc drivers etc. ?
    >can someone help on this ?
    >
    >Thanks in advance.
    >shanker
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center