I created a link to our AD server using sp_addlinkedserver, and then created a view of the information I wanted to pull. This part worked fine. Where I'm running into trouble now is I'm trying to create an asp.net website that will pull information from that view, but I get the following error:
An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'.
If I'm on the server, I can open the view without any problems, but if I use EM from my local computer to connect to the database, I get the above error if I try to open the view. Using windows integrated security, same login for both computers. SQL Server 2000, AD 2003.
I've been trying to figure out this problem for the last 2 days and I'm out of ideas. Any help is appreciated.