Distributed queries

[Lavey]

lo guys..

I Got a question, I have a stored procedure that is called from a vb app and returns a recordset. This all works fine, however.. I am planning to move this exe to another machine .. heres where the trouble starts.. both machines are logged in under the same windows account.

The exe connects to sql on a trusted connection.. no probs there.. but the sp called uses a distributed query to collect data from another server (B) using msdasql. When called from the new pc with the exe on, it gives back this message...

Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access this provider through a linked server.

Yet on the original pc and on server (A) (where the sp lives) through query analyzer it process fine..

Am I missing something fundamental here ?
Any ideas, pointers appreciated

Cheers
LaVey




____________________________________
Eat , Sleep , Live

 

[amrita418]

As the error message says, you need to create a linked server connection to access tables/data on a remote server.

Look into books online for the linked server syntax.

Regards,
AA

 

[Lavey]

I was kinda looking for a solution as to why it works like this using MSDASQL on one machine not the other...


____________________________________
Eat , Sleep , Live