I have setup a 'Microsoft OLE DB Provider for ODBC Drivers' linked
server on my Microsoft SQL 2000 (MSDE) server. The linked server is a
system DSN which connects to a informix database running on SCO unix.

I can run queries, views etc on the Windows 2000 server on which SQL is
installed. I can also run queries, views etc from and Domain Admin or
Admin login.

When I try to run these queries, views etc with any other user I
receive the following error. This particular error is happening when
running the view through ASP. Again this web page returns ok when run
using the domain admin login.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace
[Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154].

I believe this is a security problem. Any help please....

Thanks