Retrieving Linked Reports Programatically?

How do you get the properties for a linked report? Is it not possible
to do this by the linked report name? I only see 4 methods for linked
servers:
CreateLinkedReport
GetReportLink
ListLinkedReports
SetReportLink
None of which I see do any property retreiving. Am I missing
something here?
Any help is appreciated,
FrankGetProperties(), GetReportParameters() as well as some other methods should
work with linked reports.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0409030923.60765863@.posting.google.com...
> How do you get the properties for a linked report? Is it not possible
> to do this by the linked report name? I only see 4 methods for linked
> servers:
> CreateLinkedReport
> GetReportLink
> ListLinkedReports
> SetReportLink
> None of which I see do any property retreiving. Am I missing
> something here?
> Any help is appreciated,
> Frank|||I guess my question is more on the side of Creating Linked Reports
programatically. Using CreateLinkedReport works fine, but for reports
with parameters there does not seem to be a way to connect them to the
Linked Report with its own defaults. Currently, I am playing with
SetReportParameters, but it is awkward and I'm not sure this is the
way to do it.
Basically, for creating a new linked report I am pulling up the report
parameters using GetReportParameters using the Linked Report path.
Then when I call SetReportParameters using the future path of the
Linked Report I am creating.
Does this sound correct or am I on the wrong path? It doesn't seem
that many people are playing around with Linked Reports through code.
Frank
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:<#nhcjBfkEHA.536@.TK2MSFTNGP11.phx.gbl>...
> GetProperties(), GetReportParameters() as well as some other methods should
> work with linked reports.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.

Retrieve SQL servers in the network

Hi all
Is there any way to retrive all available SQL servers on the network without using the SQL DMO objects?

Thanks in advance.hello...

from SMO sample:
============================
Dim dt As DataTable
dt = Microsoft.SqlServer.Management.Smo.SmoApplication.EnumAvailableSqlServers(False)
For Each dr As DataRow In dt.Rows
serverListBox1.Items.Add(dr(0).ToString())
Next
============================|||

Thanks a lot Jung but I'm looking for a solution outside the components. i.e. an API function or something because I don’t want to deploy neither the DMO nor the SMO to my clients.
I wonder how the property pages of a UDL file can retrieve the servers without installing neither of the components

|||I don't know for sure but I am guessing that the UDL dialog uses the ODBC Function BrowseConnect or NetServerEnum. You need to call these functions via PInvoke from managed code with Fx 1.1 with Fx 2.0 there is a managed API.

Http://www.sqldev.net has further explanations.

-Euan|||Make sure your SQL Browser service is up and running.