Expand my Community achievements bar.

Help? Populate DB2 Data!

Avatar

Former Community Member
We have a DB2 database that resides on a mainframe. Can a field be populated to read from the source db2?
2 Replies

Avatar

Former Community Member
You should be able to - set up an ODBC data source pointing to the DB2 database, and then connect to it by adding an OLEDB Database connection in Designer.



When you select OLEDB, and hit Next, then hit Build, you'll get a list of OLE DB providers; one of those providers is a bridge to an ODBC data source ("Microsoft OLE DB Provider for ODBC Drivers").



--

SteveX

Adobe Systems

Avatar

Former Community Member
SteveX, thanks.



We are an UNIX shop not Microsoft, so how do I make this connection work for the UNIX environment!