Tweet
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.
-
-
SQL Server to AS400 DB2
Is it possible to connect SQL Server to an AS400 DB2 without using MS SNA Server or MS Host Integration Server? -
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