Problem solve Get help with specific problems with your technologies, process and projects.

DB2 SQL connection to MS SQL Server 2000

Could someone clarify the connectivity issue(s) with having an iSeries server accessing databases on a MS SQL Server 2000. I understand that the CONNECT SQL statement will not work and that JAVA JDBC may be the proper approach. If so, do I need any special JDBC driver on the iSeries? One article suggested downloading the JDBC driver from the MS site (Unix version). I have been unsuccessful at getting the .tar files to install. Any help or clarification would be greatly appreciated

You are correct that additional middleware is needed to access SQL Server data from an iSeries application due to the fact that Microsoft SQL Server does not support the Open Group DRDA Standard. The best interface for installing the .tar files would be use the iSeries QShell interface (STRQSH) - QShell is installed with Option 30 of the operating system.

Here's an online paper that discusses iSeries heterogenous data access.


Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.

Dig Deeper on Oracle on iSeries

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.

Please create a username to comment.