linked server from mssql 2005 to as400

I am trying to use the linked server option in mssql 2005. i have my udl connection working successfully and my odbc working. it works with Excel. I get an error when trying to link the server that reads:

"an exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)

cannot initialize the data source object of ole db provider "ibmda400" for linked server "as-400". (microsoft sql server, error:7303)

i was successful in creating the linked server with the mediacatalogmergeddb ole db provider and was able to link, but not access my table. please help!

Tried with Microsoft ole db provider for odbc driver? It worked for me.

Tried testing the connection from the ODBC or OLEDB after you installed the client tools?