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!