I don't know if this can be done or not but I'm sure I'll find the answer here.... I am using SQL Server and have stored procedures but now I also need to access DB2 tables. Is it possible for me to retrieve data from DB2 tables using SQL Server? If so can someone please share with me on how to do it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Accessing DB2 tables
- Thread starter pmcdaniel
- Start date
Try having a read up on "linked tables" in the sql server help files.
[!]
-------------------------------------------------------
Mark,
Join me at the new IT Community of the 21st Century: [!][URL unfurl="true"]http://lessthandot.com[/!][/url]
[/!]
[!]
-------------------------------------------------------
Mark,
Join me at the new IT Community of the 21st Century: [!][URL unfurl="true"]http://lessthandot.com[/!][/url]
[/!]
- Status
Similar threads
- Locked
- Question
- Locked
- Question