Hi,
I have an adp that hits a databse on an 2005SQL server (databseserver). This server needs to pull information from another table in a SQL2000 server database (DBServer). When I click on the button on a form in the adp, I get this error:
"OLE DB provider "SQLNCLI" linked server communications error"
Now the server shows up in the SQL2005 Management studio, and I can open the tables in this database on this server from the studio. Additionally, it did work until recently as we changed the sa password.
I also was able to move some databases off of the SQL2000 server and then this database failed to move; it errors out.
I do not know what I am doing and am looking for help from anyone who can help.