PDA

View Full Version : SQL Server to AS400 DB2


B.Wahl
08-22-2002, 03:46 AM
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.
Guest.Visitor
08-22-2002, 08:37 AM
Is it possible to connect SQL Server to an AS400 DB2 without using MS SNA Server or MS Host Integration Server?
Guest.Visitor
08-22-2002, 08:37 AM
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.