ODBC connection to the SQL server from the iSeries

150 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

It’s not ODBC, but see if this article from IBM helps!

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • KSC
    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.
    90 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following