Have you tried to use JDBC? I'm not sure that's what you're looking for when you say "connect", but I know that we've been able to move data back and forth using Java and the JDBC drivers for both systems.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
SQL Server to AS400 DB2
Collapse
X
-
SQL Server to AS400 DB2
Sorry for not being clearer. I want to have SQL Server use a "linked server" to the AS400. They have a stored proc for it called sp_AddLinkedServer but I'm having trouble using different OLEDB providers. Everywhere I read they say to install SNA Server or Host Integration Server. I can't do that here so I'm looking for another way. Thanks.
Comment
Comment