Home > IT Answers > AS/400 > ODBC connection to the SQL server from the iSeries
a1maida
150 pts.
 ODBC connection to the SQL server from the iSeries
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Is there a way on the iSeries to establish an ODBC connection to the SQL server?

Software/Hardware used:
ASKED: April 27, 2011  6:14 PM
UPDATED: May 5, 2011  8:52 PM
RELATED QUESTIONS
Answer Wiki:
It's not ODBC, but see if this article from IBM helps! <a href="http://www-912.ibm.com/s_dir/slkbase.NSF/0/5a3856efecb7f19f8625672b006cee76?OpenDocument">http://www-912.ibm.com/s_dir/slkbase.NSF/0/5a3856efecb7f19f8625672b006cee76?OpenDocument</a>
Last Wiki Answer Submitted:  April 27, 2011  7:37 pm  by  Koohiisan   4,990 pts.
All Answer Wiki Contributors:  Koohiisan   4,990 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If you can get Microsoft to supply you with the required ODBC driver, it should be possible. Microsoft is the SQL Server vendor and would be responsible for creating the ODBC driver that runs on AS/400s.

Since it’s unlikely that you’ll ever get such a driver from them, you will probably need to use their Type 4 JDBC driver instead. The SLKBase document in the answer mentions this.

Tom

TomLiotta
 108,125 pts.
 

i have a project that sounds similar.
We need to connect our iSeries to a MySQL database.
Our end goal is to have a program on the iSeries (COBOL) write records directly to this table. And the other side is to have a program on the other side write records directly to a file on the iSeries.
Any direction would be appreciated.

KSC
 90 pts.
 

We need to connect our iSeries to a MySQL database.

The answer is similar to that for SQL Server, but there are other considerations. You be able to use MySQL Download Connector/J as the Type 4 JDBC driver to run on your AS/400.

But because MySQL is open source with a well populated developer community, you might make some progress through adapting a MySQL ODBC driver (Connector/ODBC) to a DRDA environment, creating an ARD for native access. Hardly a trivial undertaking, but all documentation/specs should be available, potentially even some developer assistance.

And because MySQL is (i.e., more or less “was”) available for AS/400s, there might be connectivity options that no one has investigated yet.

As for going in the opposite direction, a normal iSeries Access ODBC driver (or .Net, etc.) should be what you need.

Tom

TomLiotta
 108,125 pts.