General information
Forum:
Microsoft SQL Server
Title:
Ad hoc acces to OLE DB provider 'SQLOLEDB' has been denied
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only