ODBC in AS/400, OS/400, System i, i5/OS

15 pts.
Tags:
AS/400 database
Database connectivity
i5/OS
Lotus Notes
ODBC
ODBC drivers
OS/400
System i
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).

Answer Wiki

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

On the AS400, use the WRKRDBDIRE (Work Relational Database Directory Entries) command and create a connection. You will need to supply the database or schema name, the FQDN or IP address, type of *IP and then the port number.

At that point, your code can work exactly as if you were running on a Windows server and had defined an ODBC Data Source.

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
  • Yinphin
    Thank you, EAJewett.
    15 pointsBadges:
    report
  • slack400
    I think you're going to need to install the ODBC drivers that come along with iseries access for windows. I don't think XP/Vista/WinSvr 2003/ WinSrv 2008 come with a ODBC driver set that can connect to AS400. Client access is loaded up on your IFS on the AS400 so you can always do a remote install from there if you lack the CD's.
    2,705 pointsBadges:
    report
  • SBatSI
    I am not experienced enough to evaluate EAJewett's response, but if it turns out that you do need an ODBC driver, I agree with Slack400 that the iSeries Access driver is the place to start. IBM also has a package called DB2/Connect that provides an ODBC driver, and we have been able to accomplish some things with this driver that we could not get to work with the iSeries Access driver. DB2/Connect is available through Passport Express and is reasonably priced. I hope this helps. Regards, Steve B
    415 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