Hi All,

Thanks for your replies. Below is the stored procedure which I am running.

Also my sql version is: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14...

Hi Paresh,

Thanks for the response and suggestions. On running the queries you suggested, linked server is created successfully but I am getting the below error while querying through it.

Query

Select *...

Hi Raj,

Thanks for your prompt reply. When i right click on linked server it gives me error that user must me belong to sysadmin.

Although when I login with windows...

thanks for your reply.

i installed mdac2.8 on the machine and it works fine. anybody can tell me which set of dlls required or any other things done by mdac.

i hv...