Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Link server to DB2

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-28 : 07:15:37
eugene writes "Hello,
I have to connect an old DB2 database to my SQL Server Enterprise manager. can somebody tell me how to do this. I think that I am suppose to use the "Link Server" functions but I do not know how to program it. Is it easy to do ?

Thank you.
Eugène"

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-28 : 12:07:49
You need to use sp_addlinkedserver

However,

Is it DB2 on OS/390?

As far as I know, you need a gateway...

I've been trying to go directly there using IP, but to no avail...



Brett

8-)
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-28 : 13:57:15
You can check out:

http://www.hitsw.com/products_services/sqldb2/sqldb2.html



Brett

8-)
Go to Top of Page
   

- Advertisement -