Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Ad Hoc Distributed Queries from client

Status
Not open for further replies.

CP60

Programmer
Oct 16, 2008
145
DE

Can this be done from the client? If so, then how?

oConn.Execute "sp_configure 'Ad Hoc Distributed Queries',1;"

This runs through, but no changes happen. Is it a permissions thing? If so, how do I give the connection admin permissions?
 
This doesn't look like something you want the application to be doing.

When you setup your connection you connect with an account. Whether it's your account or a specifically setup SQL account. This account has permissions levels.

If you as a dev do not have access to do this, then I would not expect your end-users to, so I would try to find another way of handling this.

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top