Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ads
Starting Member
23 Posts |
 Posted - 2012-05-02 : 07:39:49
|
| Hi,When trying to run my intranet I see the Adhoc distributed query error. So I make the adjustment on set it to 1 on the server, but then my page cannot display, website could be under maintance or a programming error? Why does this happen, the code used to run fine on server 2000 under iis 6.0Thanks |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-05-02 : 11:00:17
|
| 1. please post exact error2. what has changed in your environment? I am assuming you migrated to sql server 2008?3. can you run the query manually on your sql server<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-02 : 19:40:21
|
| but then my page cannot display, website could be under maintance or a programming error? which page are you talking about here? is it your front end webpage?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ads
Starting Member
23 Posts |
Posted - 2012-05-03 : 04:03:53
|
| All fixed. Installed Microsoft Access text Driver and turned on the Adhoc and reset a few permissions and away I went! Thanks |
|
|
|
|
|
|
Adhoc distributed queries