CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums



Zone: > NEWSGROUP > Microsoft News > microsoft.public.sqlserver.server Tags:
Item Type: Date Entered: 1/25/2008 11:42:58 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 1 Views: 48 Favorited: 0 Favorite
Can Reply:  Yes Members Can Edit: No Online: Yes
2 Items, 1 Pages |< << Go >> >|
=?Utf-8?B?SmFzb
NewsGroup User
Add And Query Linked Server To ADAM Instance...10/26/2007 3:04:01 PM
Reply

0

I was not sure if this was the best SQL Server newsgroup to post this
question to but I thought I would start here.

I would like to add a linked server to an ADAM instance and then be able to
execute queries against this linked server. It looks like I can add the
linked server but I am not sure if I am doing it right. When I try to
execute a query, I receive the following:

An error occurred while preparing the query ... for execution against OLE DB
provider "ADsDSOObject" for linked server ....

I have not been able to get around this error. From what I have read, I am
getting the impression that this is a security issue. I have tried to add
logons to the linked server but again, I am not sure if I am doing this
right. Most of the articles seem to lead me in the right direction but there
is something I am not doing correctly.

Any help with this will be most appreciated.

By the way, I am using SQL Server 2005.

Thank you,

Jason
=?Utf-8?B?bG1wc
NewsGroup User
RE: Add And Query Linked Server To ADAM Instance...10/26/2007 4:33:01 PM
Reply

0

When you created the linked server did you define the security at all? Can
you show the query you were trying to execute?

"Jason Richmeier" wrote:

> I was not sure if this was the best SQL Server newsgroup to post this
> question to but I thought I would start here.
>
> I would like to add a linked server to an ADAM instance and then be able to
> execute queries against this linked server. It looks like I can add the
> linked server but I am not sure if I am doing it right. When I try to
> execute a query, I receive the following:
>
> An error occurred while preparing the query ... for execution against OLE DB
> provider "ADsDSOObject" for linked server ....
>
> I have not been able to get around this error. From what I have read, I am
> getting the impression that this is a security issue. I have tried to add
> logons to the linked server but again, I am not sure if I am doing this
> right. Most of the articles seem to lead me in the right direction but there
> is something I am not doing correctly.
>
> Any help with this will be most appreciated.
>
> By the way, I am using SQL Server 2005.
>
> Thank you,
>
> Jason
2 Items, 1 Pages |< << Go >> >|



Free Download:
   
  Privacy | Contact Us
All Times Are GMT