ODBC in AS/400, OS/400, System i, i5/OS
Home > IT Answers > AS/400 > ODBC in AS/400, OS/400, System i, i5/OS
Yinphin
15 pts.
0
Q:
ODBC in AS/400, OS/400, System i, i5/OS
OS/400, Lotus Notes, Open Database Connectivity, ODBC, i5/OS, System i, AS/400 database, AS/400 database connectivity, ODBC drivers
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).
ASKED: Nov 6 2008  9:00 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
EAJewett
155 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Nov 6 2008  5:13 PM GMT by EAJewett   155 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Yinphin   15 pts.  |   Nov 7 2008  1:28AM GMT

Thank you, EAJewett.

 

Slack400   1165 pts.  |   Nov 7 2008  4:35PM GMT

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.

 

SBatSI   370 pts.  |   Nov 10 2008  5:26PM GMT

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

 
0