SQL DMO in .NET

[LIN]

is there an .NET equivalent of SQLDMO ?

ideas please.

thanks!

LIN

[Dejan Sarka]

Not yet .NET DMO - but you can use existing DMO like any other COM objects
in .NET apps.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIN" <ju******************@football.com> wrote in message
news:ey*************@TK2MSFTNGP12.phx.gbl...

is there an .NET equivalent of SQLDMO ?

ideas please.

thanks!

LIN

[LIN]

i tried it out. its giving all the classes
but when I am using the ListAvailableSQLServers() the result should be in
NameList
I am not able to use the NameList, Bcoz .Net Wrapper Class tells that it is
an Interface.

Need Advice

LIN

"Dejan Sarka" <de************************************@avtenta.si > wrote in
message news:#E*************@TK2MSFTNGP09.phx.gbl...

Not yet .NET DMO - but you can use existing DMO like any other COM objects
in .NET apps.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIN" <ju******************@football.com> wrote in message
news:ey*************@TK2MSFTNGP12.phx.gbl...

is there an .NET equivalent of SQLDMO ?

ideas please.

thanks!

LIN

[Hayato Iriumi]

I've programmed C# and VB .NET program against SQL DMO via COM Interop. It
works great. I personally don't think Microsoft would try to rewrite SQL DMO
piece into pure .NET code. Maybe wait until Yukon. :-)

"LIN" <ju******************@football.com> wrote in message
news:ey*************@TK2MSFTNGP12.phx.gbl...

is there an .NET equivalent of SQLDMO ?

ideas please.

thanks!

LIN

[Ivar]

Hi,

try classes starting _ eg SQLDMO._Database.

"LIN" <ju******************@football.com> wrote in message
news:eL**************@tk2msftngp13.phx.gbl...

i tried it out. its giving all the classes
but when I am using the ListAvailableSQLServers() the result should be in
NameList
I am not able to use the NameList, Bcoz .Net Wrapper Class tells that it is an Interface.

Need Advice

LIN

"Dejan Sarka" <de************************************@avtenta.si > wrote in
message news:#E*************@TK2MSFTNGP09.phx.gbl...

Not yet .NET DMO - but you can use existing DMO like any other COM objects in .NET apps.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIN" <ju******************@football.com> wrote in message
news:ey*************@TK2MSFTNGP12.phx.gbl...

is there an .NET equivalent of SQLDMO ?

ideas please.

thanks!

LIN

[LIN]

hi oj,

i'm using .NET v1.0, i have had problems.
I get an error stating: "QueryInterface for interface SQLDMO.NameList
failed."
on this partilcular line:
Dim sqlApp As New SQLDMO.Application()
Dim NL As SQLDMO.NameList, index As Long

NL = sqlApp.ListAvailableSQLServers '<<this line>>
For index = 1 To NL.Count
Console.WriteLine(NL.Item(index))
Next

Please advice.

cheers,
LIN
"oj" <no**********@home.com> wrote in message
news:#P**************@TK2MSFTNGP10.phx.gbl...

Here is a quick demo...

--
-oj
Rac v2.2 & QALite!
http://www.rac4sql.net
"LIN" <ju******************@football.com> wrote in message
news:eL**************@tk2msftngp13.phx.gbl...

i tried it out. its giving all the classes
but when I am using the ListAvailableSQLServers() the result should be in

NameList
I am not able to use the NameList, Bcoz .Net Wrapper Class tells that it

is

an Interface.

Need Advice

LIN

"Dejan Sarka" <de************************************@avtenta.si > wrote in message news:#E*************@TK2MSFTNGP09.phx.gbl...

Not yet .NET DMO - but you can use existing DMO like any other COM

objects in .NET apps.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIN" <ju******************@football.com> wrote in message
news:ey*************@TK2MSFTNGP12.phx.gbl...
> is there an .NET equivalent of SQLDMO ?
>
> ideas please.
>
> thanks!
>
> LIN
>
>
>

[oj]

This works just fine in .NET v1.0.

Dim sqlApp As New SQLDMO.Application()
Dim NL As SQLDMO.NameList, index As Int32 'Use INT32 instead of
LONG.

NL = sqlApp.ListAvailableSQLServers
For index = 1 To NL.Count
Debug.WriteLine(NL.Item(index))
Next
sqlApp = Nothing
NL = Nothing

Also, be sure to "IMPORTS SQLDMO".

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net

"LIN" <ju******************@football.com> wrote in message
news:Oz**************@tk2msftngp13.phx.gbl...

hi oj,

i'm using .NET v1.0, i have had problems.
I get an error stating: "QueryInterface for interface SQLDMO.NameList
failed."
on this partilcular line:
Dim sqlApp As New SQLDMO.Application()
Dim NL As SQLDMO.NameList, index As Long

NL = sqlApp.ListAvailableSQLServers '<<this line>>
For index = 1 To NL.Count
Console.WriteLine(NL.Item(index))
Next

Please advice.

cheers,
LIN
"oj" <no**********@home.com> wrote in message
news:#P**************@TK2MSFTNGP10.phx.gbl...

Here is a quick demo...

--
-oj
Rac v2.2 & QALite!
http://www.rac4sql.net
"LIN" <ju******************@football.com> wrote in message
news:eL**************@tk2msftngp13.phx.gbl...

i tried it out. its giving all the classes
but when I am using the ListAvailableSQLServers() the result should be in NameList
I am not able to use the NameList, Bcoz .Net Wrapper Class tells that

it

is

an Interface.

Need Advice

LIN

"Dejan Sarka" <de************************************@avtenta.si >

wrote in message news:#E*************@TK2MSFTNGP09.phx.gbl...
> Not yet .NET DMO - but you can use existing DMO like any other COM

objects

> in .NET apps.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "LIN" <ju******************@football.com> wrote in message
> news:ey*************@TK2MSFTNGP12.phx.gbl...
> > is there an .NET equivalent of SQLDMO ?
> >
> > ideas please.
> >
> > thanks!
> >
> > LIN
> >
> >
> >
>
>