How to Connect Server 2008 to AS400

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

To query the data tables in the as400 from windows

So it has to be the Enterprise version...?

Do you mean SQL Server? No, you don't need Enterprise edition to create linked servers.

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

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

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

I got it to link as a server.

Now just need the tbles to be in my view so I can query them

So what happens when you try to access a table?

I do not see a table.... Here is my view