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 |
|
Auric
Yak Posting Veteran
70 Posts |
 Posted - 2005-11-21 : 08:34:26
|
| Hey All!One of our business partners has an AS400 that we would like to be able to transfer information to through a DTS job. The network connectivity is all set and ready to go via VPN but now I am just looking for some documentation on linking the two together... Any suggestions?Thanks!JoshSelect * from users where clue > 0 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-21 : 11:44:02
|
emmm... linked server??BOL has all the Info you need.Go with the flow & have fun! Else fight the flow  |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-11-21 : 12:45:55
|
| Link to an AS400 hummmm let me think about this........Take 1/2 a pound of plastic explosive and place under the As400......Sorry I had to put up with that AS400 piece of junk for years and just seeing "AS400" makes me see Red. JimUsers <> Logic |
|
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-11-21 : 14:11:13
|
| hahaha I don't think they would like that too much, but I couldn't agree more.Select * from users where clue > 0 |
|
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-11-23 : 13:43:16
|
| Well as it turns out the other company didn't have the correct port forward on their firewall... no wonder I wasn't getting any connectivity.Select * from users where clue > 0 |
|
|
|
|
|
|
Linking AS400/DB2 server as a remote server in sql