SQL Server 2005 with iSeries DB2 Linked Server problem

Thanks in advance for any help.

I have the linked server(named AS400) set up and and I can execute the
following query from the SQL Server Management Studio and it works
perfectly.

I can even create a view (dbo.PSIA301) of the query in my Master
database and it works from the SQL Server.

When I try to connect the SQL Server from an external querying tool
(DbVisualizer Personal) and execute either the query or the enumerate
the data from the view, I get the following messages:

[SELECT - 0 row(s), 0.000 secs] [Error Code: 7399, SQL State: 37000]
[Microsoft][ODBC SQL Server Driver][SQL Server]The OLE DB provider
"IBMDA400" for linked server "AS400" reported an error. Access denied.
select * from dbo.PSIA301;
.... 1 statement(s) executed, 0 row(s) affected, exec/fetch time:
0.000/0.000 sec [0 successful, 0 warnings, 1 errors]

Any ideas?

.

Relevant Pages

  • Re: SQL Query Performance
    ... Execute the query and see which is faster. ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > I want to select Fleet_Id and Fleet_Name from fleet table> Where the current user has privilege. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2000 manual start job sort order
    ... As you might know, without ORDER BY, SQL Server is free to optimize and execute a query in any way ... then the optimizer has to ...
    (microsoft.public.sqlserver.server)
  • Re: Parameterized query problem using Access Database in VS.NET2005
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... I want to have pramized query, ... I use SQL Server Management Studio Express and I applied the same ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Closing a connection BEFORe command execution has completed
    ... closing the connection with Connection.Close does not close the connection--it simply releases it back to the pool so the engine will continue to fill the cache--but it's not that large so the operation might simply hang resources on the server until the connection is reused. ... The problem is, since all of the Execute methods are synchronous, there is no way to interrupt the query or action command process. ... Because of the way TDS and SQL Server responds to cancel requests your operation might not be immediately "stoppable"--SQL Server might have some cleanup to do before releasing control and resources. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Could not find stored procedure
    ... To add on to Dejan Sarka post, Simply execute the below query in Query ... > loin is mapped to a specific db user dbo, so SQL Server searches dbo.name ...
    (microsoft.public.sqlserver.server)