Creating a Linked Server to AS400 in SQL Server 2005

I am trying to create a linked server in SQL Server 2005 to show tables in our AS400. I made the connection, however, the tables are not showing up under the Linked Server name.

How do you get the linked tables to display in the Linked Server folder?

David

Are you sure you did provide the right catalog ? If you don't have access rights to the catalog or to specific objcts you also won't see them in the list. Make sure that the user associated with the linked server has the appropiate rights to see the objects.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

I am trying almost the same thing. But I am not even able to create the connection to the server.

I tried it like this:

Provider: Microsoft OLE DB Provider for ODBC Driver

Product name: IBMDASQL ?

Data source: MyAS400

Catalog: MyCatalog

And I create a local login.

When I try to access the database with a query I get the error: can not start the connection. Do you know what is wrong with my Link Server

|||

I downloaded a new driver from the Microsoft website: Microsoft OLEDB Provider for DB2

I had better success with this:

When setting up the connection, I used the following settings:

Settings:

Data Source (Enter IP address of AS/400)

NetworkTCP/IP Connect…. (Enter IP address of AS/400)

Single sign on is unchecked

Username

Pw

Initial Catalog : AS/400 System name (from the sign on screen)

Package: QSYS

Default Schema: (Enter name of Library where data is located )

Advanced Tab: DB2/400

Hope this helps.

David