Opendatasource provides the means to create adhoc connections. It uses a linked server object. You can access server locally or remotely. You can add the same kind of parameters as a linked server object including username and password. If you need to access a remote server using an ole db provider such as the "Microsoft.ACE.OLEDB.12.0" you need to set the registry option "DisallowAdhocAcces " to 0 and of course the Ad hoc Distributed
No comments:
Post a Comment