Accessing Linked Servers via ADO.NET

[Guest]

I have a SQL Server 2005 instance. On it are a bunch of databases and a
linked server. ADO.NET easily accesses all the named databases on this
server. However, I would like to access data through a linked server on the
same instance of SQL Server. However, the GUI of the DataAdapters won't allow
it.

Is it possible to make ADO.NET access data through a linked server or must I
connect to the server directly?

 

[WenYuan Wang [MSFT]]

Hi Michael,
As far as I know, we can access data on a linked server through ADO.NET by
the OpenQuery syntax. Do you meet any further issue on this? Please let me
know and I'll follow up.

Have a great day,
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Cowboy \(Gregory A. Beamer\)]

The other option is to add sprocs on the main server to bridge the gap. No
matter how you do this, you have to be careful, as you could open an
unintentional security hole.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*********************************************
Think outside the box!
*********************************************