DB2 and sql server 7 database connectivity

[shank]

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

[Mark]

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
>
>

[ElGalin]

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
>>
>>
>

[Sharon]

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
>
>