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.
| Author |
Topic |
|
label
Posting Yak Master
197 Posts |
 Posted - 2003-03-03 : 14:39:49
|
| Is there anyway to make a call to a DB2 database from inside a Stored Proc on SQL2000? Thanks. |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-03-03 : 15:06:45
|
| Do a search on Linked servers and/ or OpenQuery(). I think one of those will help you.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-03 : 15:47:22
|
| Yeah, but thats the easy part...establishing the connection is that hard part. I've been trying to hit it directly without a gateway, but the gateway seems to be the prefered method. Even our Tech shops isn't a fan of doing this.Anyway, check out this link:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=23989Brett8-) |
|
|
|
label
Posting Yak Master
197 Posts |
Posted - 2003-03-04 : 07:30:38
|
quote:
Yeah, but thats the easy part...establishing the connection is that hard part. I've been trying to hit it directly without a gateway, but the gateway seems to be the prefered method.
Hmmm. I thought that establishing a linked server and using the openquery seemed to easy. I'll post next questions in the other thread as it has more history. |
|
|
|
|
|
|
I doubt it but.....