Hi,
We have a link server
runnig on the SQL 2005 Express. My stored procedures runs fine.
But when I put the same settings in SQL 2008 Express which locates in the web server. The store procedure returns the following error message.
how can solve this?
We have a link server
runnig on the SQL 2005 Express. My stored procedures runs fine.
But when I put the same settings in SQL 2008 Express which locates in the web server. The store procedure returns the following error message.
Code:
execution against OLE DB provider "ADsDSOObject" fro linked server abc