Connect an SQL Server from the iSeries

It has always been difficult to connect to a SQL Server database running on Windows from an AS400.DRDA, which is not supported by Windows. The answer so far has been to use a tool such as DataJoiner. Now with Java Tool Box running on the iSeries, it's possible to connect to a SQL Server from the iSeries.

This is how I did it:

I read a DB2 table on the iSeries and updated it on a table in SQL Server in another Windows machine. We are on V4R5 and have JDK and Java Toolbox loaded on the machine along with Qshell. Toolbox for Java gives a driver called com.ibm.as400.access.AS400JDBCDriver(). I got the Type 4 JDBC driver for SQL Server 2000, which runs on a Unix server from the Microsoft site. I kept the jar files where the native driver for iSeries was kept. The Java program that I coded used the iSeries native driver to connect to local DB2 and also to SQL Server 2000 remotely.


    Requires Free Membership to View

    Login

This was first published in February 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.

    Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

    Back to top