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
6  1242 
Check out System.Data.Sql .SqlDataSourceE numerator.GetDa taSources()
"Nathan M" <Na*****@discus sions.microsoft .com> wrote in message
news:82******** *************** ***********@mic rosoft.com...
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
Hi,
Add a reference to microsoft.sqlse rver.smo
Imports Microsoft.SqlSe rver.Management .Smo
Public Class Form1
Private Sub Form1_Load(ByVa l sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim dt As DataTable
'Get list of servers
dt = SmoApplication. EnumAvailableSq lServers(False)
For Each dr As DataRow In dt.Rows
ListBox1.Items. Add(dr(0).ToStr ing)
Next
End Sub
End Class
Ken
----------------------------
"Nathan M" <Na*****@discus sions.microsoft .com> wrote in message
news:82******** *************** ***********@mic rosoft.com... 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
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
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:uG******** ******@TK2MSFTN GP15.phx.gbl... Hi,
Add a reference to microsoft.sqlse rver.smo
Imports Microsoft.SqlSe rver.Management .Smo
Public Class Form1
Private Sub Form1_Load(ByVa l sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim dt As DataTable
'Get list of servers
dt = SmoApplication. EnumAvailableSq lServers(False)
For Each dr As DataRow In dt.Rows
ListBox1.Items. Add(dr(0).ToStr ing)
Next
End Sub
End Class
Ken
----------------------------
"Nathan M" <Na*****@discus sions.microsoft .com> wrote in message
news:82******** *************** ***********@mic rosoft.com... 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
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" <gr*********@RE MOVEbtopenworld .com> schreef in bericht
news:dl******** **@nwrdmz01.dmz .ncs.ea.ibs-infra.bt.com... 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
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:uG******** ******@TK2MSFTN GP15.phx.gbl... Hi,
Add a reference to microsoft.sqlse rver.smo
Imports Microsoft.SqlSe rver.Management .Smo
Public Class Form1
Private Sub Form1_Load(ByVa l sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim dt As DataTable
'Get list of servers
dt = SmoApplication. EnumAvailableSq lServers(False)
For Each dr As DataRow In dt.Rows
ListBox1.Items. Add(dr(0).ToStr ing)
Next
End Sub
End Class
Ken
----------------------------
"Nathan M" <Na*****@discus sions.microsoft .com> wrote in message
news:82******** *************** ***********@mic rosoft.com... 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
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 :D
_______________ _______________ _______________ __
The Grim Reaper
"Michel van den Berg" <mv*@promontis. nl> wrote in message
news:uq******** ******@TK2MSFTN GP12.phx.gbl... 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" <gr*********@RE MOVEbtopenworld .com> schreef in bericht
news:dl******** **@nwrdmz01.dmz .ncs.ea.ibs-infra.bt.com... 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
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:uG******** ******@TK2MSFTN GP15.phx.gbl... Hi,
Add a reference to microsoft.sqlse rver.smo
Imports Microsoft.SqlSe rver.Management .Smo
Public Class Form1
Private Sub Form1_Load(ByVa l sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim dt As DataTable
'Get list of servers
dt = SmoApplication. EnumAvailableSq lServers(False)
For Each dr As DataRow In dt.Rows
ListBox1.Items. Add(dr(0).ToStr ing)
Next
End Sub
End Class
Ken
----------------------------
"Nathan M" <Na*****@discus sions.microsoft .com> wrote in message
news:82******** *************** ***********@mic rosoft.com...
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
Sorry my mistake, please don't kill me! ;)
"The Grim Reaper" <gr*********@RE MOVEbtopenworld .com> schreef in bericht
news:dl******** **@nwrdmz03.dmz .ncs.ea.ibs-infra.bt.com... 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 :D
_______________ _______________ _______________ __
The Grim Reaper
"Michel van den Berg" <mv*@promontis. nl> wrote in message
news:uq******** ******@TK2MSFTN GP12.phx.gbl...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" <gr*********@RE MOVEbtopenworld .com> schreef in bericht
news:dl******** **@nwrdmz01.dmz .ncs.ea.ibs-infra.bt.com... 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
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:uG******** ******@TK2MSFTN GP15.phx.gbl...
Hi,
Add a reference to microsoft.sqlse rver.smo
Imports Microsoft.SqlSe rver.Management .Smo
Public Class Form1
Private Sub Form1_Load(ByVa l sender As Object, ByVal e As
System.EventArg s) Handles Me.Load
Dim dt As DataTable
'Get list of servers
dt = SmoApplication. EnumAvailableSq lServers(False)
For Each dr As DataRow In dt.Rows
ListBox1.Items. Add(dr(0).ToStr ing)
Next
End Sub
End Class
Ken
----------------------------
"Nathan M" <Na*****@discus sions.microsoft .com> wrote in message
news:82******** *************** ***********@mic rosoft.com...
> 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Frances Del Rio |
last post by:
pls, why is this not working?
<SCRIPT language=JavaScript type="text/javascript">
var br = '<SCRIPT language=Javascript'
br += 'src="js_pop.js" type="text/javascript">'
br += '</SCRIPT>'
var op = '<SCRIPT language=Javascript'
op += 'src="js_pop-op.js" type="text/javascript">'
op += '</SCRIPT>'
if (navigator.userAgent.indexOf('Opera') != -1 ) {
|
by: Suresh Kumaran |
last post by:
Hi All,
I have a Form which has three tab controls and each tab
control has text boxes and combo boxes and Data time
picker etc, totalling up to 50 instances in all three tab
controls. How do I inform the user if any one of the
instances is changed in any tab control to save the data
before exiting the application?. I don't want create the
text changed event handler for all 50 instances. Is there
an easy way to do this?
|
by: News Admin |
last post by:
I have a bunch of classes, instances of which that need to live in shared
memory and be accessed by multiple processes. This means that they cannot
have a vtable as the addresses in it will be in the address space of the
process that originally created the shared memory and therefore unavailable
to the other processes that may wish to use these instances of the classes.
Every so often I forget this and introduce a virtual function causing...
|
by: Rob Gibson |
last post by:
Can someone please point me to some code (preferably C#, but C++ or C or VB
will work) that will detect if the (local) instance of SQL Server is
running on a machine or not? Many thanks!
-- Rob
|
by: Mike |
last post by:
Looking to find any information on how to properly configure multiple
instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking
for information on how the multiple instance settings should
configured to work, how memory is shared or not, etc. I can not seem
to find any good links to this information.
Thanks,
Mike
| | |
by: D. Shane Fowlkes |
last post by:
I'm using SQL Server 2000 and on my page, I'm simply creating a
SQLDataReader and filling in Labels with the retrieved (single) record.
However, how can I prevent from getting errors when a field is null?
I've tried something like this (experimenting with IsDBNull):
=========================================================
If dtrData.IsDBNull("Address2") = True Then
lblAddress2.Text = ""
Else
|
by: Chris Newby |
last post by:
I realize that I can handle "SessionEnd" from global.asax ... but it appears
to me that this gets called without the context of a current web request. So
given the following scenario:
User logs in and session starts
User is inactive longer than the session timeout setting
Some thread, not associated with a request, detects the timeout and raises
Session_End()
The User comes back to the site presenting a timed-out session id
ASP.NET...
|
by: 440gtx |
last post by:
I have a class that maintains a static std::list of its instances.
Thus, due to the order of constructors ambiguity of itself and
std::list, it cannot be safely instantiated until after main is
called. What I would like to do is put in an assert if it is
instantiated too early, but unsure how to detect this case. Or perhaps
there is a better design for instance tracking?
|
by: =?Utf-8?B?UGV0ZXI=?= |
last post by:
I'm trying to get a list of SQL Server Instances thru a VB.NET application.
I have tried GetDataSource and SMO. I have also tried using ListSQLSvr.exe
from http://www.sqldev.net/misc/ListSQLSvr.htm
I run all of them on a Windows XP Professional 64bit machine which has 2
instances: mymachine\SQLExpress (Express Edition) and MSSQLSERVER (Developer
Edition (64bit))
SQL Browser Service: not running
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
