|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Successor to SQL-DMO?What is now the officially sanctioned way of obtaining schema information in
a program now that SQL-DMO is supposed to be old technology? SMO:
http://msdn2.microsoft.com/en-us/library/ms162169.aspx -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinpub.com .. "Neil W." <ne***@netlib.com> wrote in message What is now the officially sanctioned way of obtaining schema information innews:%237osiyuTGHA.4236@tk2msftngp13.phx.gbl... a program now that SQL-DMO is supposed to be old technology? Thanks for the reply. Do you know if
a) SMO works with VB6, or does it require dotnet? b) Does it work with SQL 2000 and SQL7, or just SQL 2005? c) Does it work with Windows 98/ME? Thanks. Show quote "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message > SMO: > > http://msdn2.microsoft.com/en-us/library/ms162169.aspx > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA > SQL Server MVP > Columnist, SQL Server Professional > Toronto, ON Canada > www.pinpub.com > . > "Neil W." <ne***@netlib.com> wrote in message > news:%237osiyuTGHA.4236@tk2msftngp13.phx.gbl... > What is now the officially sanctioned way of obtaining schema information > in > a program now that SQL-DMO is supposed to be old technology? > > > a) SMO works with VB6, or does it require dotnet? It is a managed API, to it requires .NET.> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? 2005 and 2000. Not 7.0.> c) Does it work with Windows 98/ME? I very much doubt that .NET is available for W98/ME...-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Neil W." <ne***@netlib.com> wrote in message news:O20C%23A0TGHA.3888@TK2MSFTNGP10.phx.gbl... > Thanks for the reply. Do you know if > > a) SMO works with VB6, or does it require dotnet? > b) Does it work with SQL 2000 and SQL7, or just SQL 2005? > c) Does it work with Windows 98/ME? > > Thanks. > > "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message >> SMO: >> >> http://msdn2.microsoft.com/en-us/library/ms162169.aspx >> >> -- >> Tom >> >> ---------------------------------------------------- >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA >> SQL Server MVP >> Columnist, SQL Server Professional >> Toronto, ON Canada >> www.pinpub.com >> . >> "Neil W." <ne***@netlib.com> wrote in message >> news:%237osiyuTGHA.4236@tk2msftngp13.phx.gbl... >> What is now the officially sanctioned way of obtaining schema information in >> a program now that SQL-DMO is supposed to be old technology? >> >> > > Thanks - so there is no single technology that a program can use to access
SQL regardless of version or OS? -------------------------- Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message >> a) SMO works with VB6, or does it require dotnet? > > It is a managed API, to it requires .NET. > > >> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? > > 2005 and 2000. Not 7.0. > > >> c) Does it work with Windows 98/ME? > > I very much doubt that .NET is available for W98/ME... > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Neil W." <ne***@netlib.com> wrote in message > news:O20C%23A0TGHA.3888@TK2MSFTNGP10.phx.gbl... >> Thanks for the reply. Do you know if >> >> a) SMO works with VB6, or does it require dotnet? >> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? >> c) Does it work with Windows 98/ME? >> >> Thanks. >> >> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message >>> SMO: >>> >>> http://msdn2.microsoft.com/en-us/library/ms162169.aspx >>> >>> -- >>> Tom >>> >>> ---------------------------------------------------- >>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA >>> SQL Server MVP >>> Columnist, SQL Server Professional >>> Toronto, ON Canada >>> www.pinpub.com >>> . >>> "Neil W." <ne***@netlib.com> wrote in message >>> news:%237osiyuTGHA.4236@tk2msftngp13.phx.gbl... >>> What is now the officially sanctioned way of obtaining schema >>> information in >>> a program now that SQL-DMO is supposed to be old technology? >>> >>> >> >> > > I didn't say for sure that .NET isn't available under W9x, it was only an assumption. You might want
to check in an .NET group to make sure (or do a test). Also, I just noticed in BOL that in one place it mentions that SMO supports SQL7, so perhaps that was a confusion of the fact that SSMS doesn't manage SQL7 instances...? -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Neil W." <ne***@netlib.com> wrote in message news:O2Dyh31TGHA.3192@TK2MSFTNGP09.phx.gbl... > Thanks - so there is no single technology that a program can use to access SQL regardless of > version or OS? > > -------------------------- > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message >>> a) SMO works with VB6, or does it require dotnet? >> >> It is a managed API, to it requires .NET. >> >> >>> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? >> >> 2005 and 2000. Not 7.0. >> >> >>> c) Does it work with Windows 98/ME? >> >> I very much doubt that .NET is available for W98/ME... >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Neil W." <ne***@netlib.com> wrote in message news:O20C%23A0TGHA.3888@TK2MSFTNGP10.phx.gbl... >>> Thanks for the reply. Do you know if >>> >>> a) SMO works with VB6, or does it require dotnet? >>> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? >>> c) Does it work with Windows 98/ME? >>> >>> Thanks. >>> >>> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message >>>> SMO: >>>> >>>> http://msdn2.microsoft.com/en-us/library/ms162169.aspx >>>> >>>> -- >>>> Tom >>>> >>>> ---------------------------------------------------- >>>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA >>>> SQL Server MVP >>>> Columnist, SQL Server Professional >>>> Toronto, ON Canada >>>> www.pinpub.com >>>> . >>>> "Neil W." <ne***@netlib.com> wrote in message >>>> news:%237osiyuTGHA.4236@tk2msftngp13.phx.gbl... >>>> What is now the officially sanctioned way of obtaining schema information in >>>> a program now that SQL-DMO is supposed to be old technology? >>>> >>>> >>> >>> >> >> > > Incidentally - how does Query Analyzer enumerate the SQL instances - does it
use the ListAvailableSQLServers method? Thanks. ------------------ Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message >> a) SMO works with VB6, or does it require dotnet? > > It is a managed API, to it requires .NET. > > >> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? > > 2005 and 2000. Not 7.0. > > >> c) Does it work with Windows 98/ME? > > I very much doubt that .NET is available for W98/ME... > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Neil W." <ne***@netlib.com> wrote in message > news:O20C%23A0TGHA.3888@TK2MSFTNGP10.phx.gbl... >> Thanks for the reply. Do you know if >> >> a) SMO works with VB6, or does it require dotnet? >> b) Does it work with SQL 2000 and SQL7, or just SQL 2005? >> c) Does it work with Windows 98/ME? >> >> Thanks. >> >> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message >>> SMO: >>> >>> http://msdn2.microsoft.com/en-us/library/ms162169.aspx >>> >>> -- >>> Tom >>> >>> ---------------------------------------------------- >>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA >>> SQL Server MVP >>> Columnist, SQL Server Professional >>> Toronto, ON Canada >>> www.pinpub.com >>> . >>> "Neil W." <ne***@netlib.com> wrote in message >>> news:%237osiyuTGHA.4236@tk2msftngp13.phx.gbl... >>> What is now the officially sanctioned way of obtaining schema >>> information in >>> a program now that SQL-DMO is supposed to be old technology? >>> >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics