| m.jennings@mardenedwards.com 2006-03-17, 7:23 am |
| 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
|