Detecting instances of SQL Server

[Guest]

Hi,

I have a few projects with which I am using Access as a backend. I am
thinking about upgrading them to the .NET framework 2.0 and switching to SQL
Server. First I want to make sure I can still run the programs on a home
network environment. I want to be able to install the main SQL databases on
one computer and have other computers access those on the network. Is there
a way in VB 2005 for computers to search for instances of SQL on the network?

Thanks,
Nathan

 

[Siva M]

Check out System.Data.Sql.SqlDataSourceEnumerator.GetDataSources()

Hi,

I have a few projects with which I am using Access as a backend. I am
thinking about upgrading them to the .NET framework 2.0 and switching to SQL
Server. First I want to make sure I can still run the programs on a home
network environment. I want to be able to install the main SQL databases
on
one computer and have other computers access those on the network. Is there
a way in VB 2005 for computers to search for instances of SQL on the
network?

Thanks,
Nathan

 

[Ken Tucker [MVP]]

Hi,

Add a reference to microsoft.sqlserver.smo

Imports Microsoft.SqlServer.Management.Smo

Public Class Form1


Private Sub Form1_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim dt As DataTable



'Get list of servers

dt = SmoApplication.EnumAvailableSqlServers(False)

For Each dr As DataRow In dt.Rows

ListBox1.Items.Add(dr(0).ToString)

Next


End Sub
End Class



Ken

 

[The Grim Reaper]

Hi Ken,

I can't find that reference. I've got both SQL Server 2000 and SQL Server
2005 Express installed.
Is it only available with a proper SQL 2005 version??

TIA
___________________________________________
The Grim Reaper

 

[Michel van den Berg]

I think this article might answer your second problem:
http://www.sqldbatips.com/showarticle.asp?ID=35

Hope I helped you,

Michel van den Berg

 

[The Grim Reaper]

It wasn't my second problem - it was my first and only problem - I'm not the
OP!!

Thanks anyway - t'was a great help
_______________________________________________
The Grim Reaper

 

[Michel van den Berg]

Sorry my mistake, please don't kill me!

It wasn't my second problem - it was my first and only problem - I'm not
the OP!!

Thanks anyway - t'was a great help
_______________________________________________
The Grim Reaper