Q

DB2/400 to SQL server connectivity

Could you please elaborate on the iSeries to Microsoft SQL Server/2000 connectivity issues? I need to be able to...

connect from the iSeries to the SQL Server and vice versa. Can I use a CONNECT TO statement? If I need to use Java and JDBC, do I need to use a special driver other than the tool kits?

Connecting from Microsoft to DB2 is easy, you should install ODBC driver (for example Client Access ODBC driver) or ado provider (for example Client Access) this allows direct connection from SQL server to DB2 on iSeries.

Connecting from DB2 to Microsoft SQL is more difficult since the SQL server doesn't support DRDA and the iSeries connect verb uses DRDA. JDBC is an option, yet it requires you to write your application on the iSeries in Java so the best you could do is use a product described very well here by Kent Milligan He answers in detail the issue of iSeries to other databases issue.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.


This was last published in October 2002

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close