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

Connecting to an SQL server

I am trying to access data on an MS SQL Server 2000 from my iSeries. Is there a way to create an ODBC connection from the iSeries to the MS SQL Server machine for my application to access the SQL server data?
The iSeries supports connection to other databases using DRDA. Because the SQL server (and oracle) does not support DRDA requests, it is not possible to do a simple "connect" to the SQL server.

Alternatives:

* Use Java: Install a pure JDBC driver on the iSeries and use a Java program to connect to the SQL server. This requires you to code Java, but it is FREE and does not require any extra software. We "wrapped" the Java code for some of our customers (that means the customer uses RPG to call our Java that does the JDBC work).

* Buy, install and implement a product to help you. Some products:

* rpg2sql from RJS.
* Attunity connect from Attunity
* IBM's DB2 information integrator

You'll also want to read Kent Milligan's excellent white paper on this issue.

Please note:

This response from Shahar is the same as the following question: Reading SQL server tables

==================================
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.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.


This was last published in March 2004

Dig Deeper on FTP

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.

-ADS BY GOOGLE

SearchDataCenter

  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...

Close