Hi all,

yesterday is had a question about inserting data from a table in a database on another server. Very quicly I got the answer to use the openrowset method. Problem is, when I try this method in one of our POS, I get the following error: "Ad hoc acces to OLE DB provider 'SQLOLEDB' has been denied. You must access this provider through a linked server."

How can I resolve this problem without using a linked server ?

Greetz,
Hans