It sounds like the error is from the linked server defined incorrectly on SQL Server.
You say yhou are accessing the tables from your client machine. If the SQL Server is on a different machine, remember that you need to set up the ODBC DSN (or the 'DB2OLEDB' driver) on the server, not your client.
See sp_addlinkedserver in BOL for a description of what is needed.
Please provide more information if this does not help or is unclear.
Originally posted by pholtquist
I have found an
issue when I try to view or access the tables on the AS400 from my client machine. I receive the following error when I make that attempt:
Error 7399: OLE DB Provider 'MSDASQL' reported an error.
Data Source Name not found and no default driver specified.
Any help anyone can give me on this issue would be greatly appreciated