How to Connect Server 2008 to AS400

Anyone have an idea or link to how to setup the Server 2008 (Microsoft) to AS400 DB2?



Thanks
jaymz69Asked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
First you need to install DB2 driver (unzip and run installer).
DB2 OLEDB Microsoft Driver

Next you need to create linked server using installed DB2 driver.
Create a linked server to access a DB2 database
How to create a SQL Server linked server to DB2 (free reg or scroll down)
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
Link AS/400 DB2 to what in Win 2008, for what purpose, using what Windows data access tool, programming language, or Windows DBMS?

- Gary Patterson
0
 
jaymz69Author Commented:
To query the data tables in the as400 from windows
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
jaymz69Author Commented:
So it has to be the Enterprise version...?
0
 
Daniel_PLDB Expert/ArchitectCommented:
Do you mean SQL Server? No, you don't need Enterprise edition to create linked servers.
0
 
jaymz69Author Commented:
The db does not download. Shows " Setup cannot continue because a supported version of SQL Server 2005 or greater is not installed. Supported versions include Enterprise, Developer, Enterprise Evaluation"

I have 2088 installed
0
 
Daniel_PLDB Expert/ArchitectCommented:
Yes, unfortunately this driver is licensed for Enterprise edition of SQL Server. The ODBC should be included with iSeries Access for Windows - use IBM cd/dvd

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzaik%2Frzaikoledbprovider.htm
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
For SQL 2008, the MS DB2 OLEDB provider is part of the Host Integration Server:

http://www.microsoft.com/biztalk/en/us/host-integration.aspx

IBM supplies a free OLEDB provider, however, as part of IBM i Access, which is distributed with every AS/400.  Ask your AS/400 administrator for installation media. This is not available for public download, but you can order media from IBM if your is lost.

http://www-03.ibm.com/systems/i/software/access/

- Gary Patterson
0
 
jaymz69Author Commented:
I got it to link as a server.

Now just need the tbles to be in my view so I can query them
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
So what happens when you try to access a table?
0
 
jaymz69Author Commented:
I do not see a table.... Here is my view
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.