Accessing one Database from two PC's

Hi ,
Can anyone please give me some thoughts on how to achieve the
following:-
I have a SCADA system updating an SQL database using MSDE on a PC.
I have an analysis tool from which I want to access the same database
with also using MSDE via ADO from a second machine (here the updates
won't be continuous, but queries two or three times a day).
How would I effectively connect both processes to the same database ?
Many Thanks
Vic
Vic,
I'm not sure what your "real" problem is (I have no experience in SCADA
systems). Do you mean that you will have performance problems if you
query the database at the same time it is updated? 2-3 querys a day
doesn't seem to be "a lot", but it depends on the querys...
There is no problem "connecting" (more than one) process to the same
database (as long as you don't have the database in single-user mode).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Victor. d'Hoop wrote:
> Hi ,
> Can anyone please give me some thoughts on how to achieve the
> following:-
> I have a SCADA system updating an SQL database using MSDE on a PC.
> I have an analysis tool from which I want to access the same database
> with also using MSDE via ADO from a second machine (here the updates
> won't be continuous, but queries two or three times a day).
> How would I effectively connect both processes to the same database ?
> Many Thanks
> Vic
|||Lars,
I guess my question is really, can I attach a database to more than
one server ?
Cheers
Vic
On Tue, 22 Mar 2005 17:23:20 +0100, Lars Broberg
<lars.b@.elbe-data.nothing.se> wrote:
[vbcol=seagreen]
>Vic,
>I'm not sure what your "real" problem is (I have no experience in SCADA
>systems). Do you mean that you will have performance problems if you
>query the database at the same time it is updated? 2-3 querys a day
>doesn't seem to be "a lot", but it depends on the querys...
>There is no problem "connecting" (more than one) process to the same
>database (as long as you don't have the database in single-user mode).
>Lars Broberg
>Elbe-Data AB
>http://www.elbe-data.se
>Remove "nothing." when replying to private e-mail!
>
>Victor. d'Hoop wrote:
|||Vic,
Why have two servers? Isn't is possible to connect to the _same_ server
from both clients?
If you _really_ need this, use backup and restore, if you don't need
"live" data for the querying. Otherwise look at replication...
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Victor. d'Hoop wrote:
> Lars,
> I guess my question is really, can I attach a database to more than
> one server ?
> Cheers
> Vic
> On Tue, 22 Mar 2005 17:23:20 +0100, Lars Broberg
> <lars.b@.elbe-data.nothing.se> wrote:
>
>
|||Vic,
To clarify, you can't attach "the same" mdf/ldf files to two different
servers at the same time. You can of course copy the mdf/ldf files to
two different places and attach these different file pairs to different
servers (but then you have two "different" databases...).
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Lars Broberg wrote:[vbcol=seagreen]
> Vic,
> Why have two servers? Isn't is possible to connect to the _same_ server
> from both clients?
> If you _really_ need this, use backup and restore, if you don't need
> "live" data for the querying. Otherwise look at replication...
> Lars Broberg
> Elbe-Data AB
> http://www.elbe-data.se
> Remove "nothing." when replying to private e-mail!
>
> Victor. d'Hoop wrote:
|||Lars,
Let me try to explain better.
There are two PC's which are networked.
PC A needs to write information to the database on a regular basis.
PC B needs to read information from the database on a regular basis.
Is there some way that both PC's can use the same server ?
From what I can see one of them won't have MSDE available to it. On
the other hand, I wouldn't be surprised if I'm overlooking something
obvious.
Many thanks for your patience. I'm used to dealing with .dbf's so I
find it difficult to get my head around this.
Cheers
Vic
On Wed, 23 Mar 2005 09:06:38 +0100, Lars Broberg
<lars.b@.elbe-data.nothing.se> wrote:
[vbcol=seagreen]
>Vic,
>To clarify, you can't attach "the same" mdf/ldf files to two different
>servers at the same time. You can of course copy the mdf/ldf files to
>two different places and attach these different file pairs to different
>servers (but then you have two "different" databases...).
>Lars Broberg
>Elbe-Data AB
>http://www.elbe-data.se
>Remove "nothing." when replying to private e-mail!
>
>Lars Broberg wrote:
|||Vic,
They can use the same server. MSDE 2000 SP3a is installed as default
without network support (DISABLENETWORKPROTOCOLS=1). You can change this
when you install (set the parameter to zero) or you may use
Network Utility to configure MSDE (use DbaMGR2k on the PC where you can
connect to MSDE and look in the menu "Tools & Settings"):
1.On the General tab, select the instance from the instance list (you
probably only have one).
2.Under Disabled protocols, click the protocol (such as TCP/IP)you want
to enable, and then click Enable.
3.Click OK.
4.Stop and restart the service to make any changes take effect.
If you have MSDE installed on a PC with Win XP/SP2, you have to manually
open TCP/IP port 1433 in the XP firewall. For testing, you can just
disable the firewall, but remember to activate it again...
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Victor. d'Hoop wrote:
> Lars,
> Let me try to explain better.
> There are two PC's which are networked.
> PC A needs to write information to the database on a regular basis.
> PC B needs to read information from the database on a regular basis.
> Is there some way that both PC's can use the same server ?
> From what I can see one of them won't have MSDE available to it. On
> the other hand, I wouldn't be surprised if I'm overlooking something
> obvious.
> Many thanks for your patience. I'm used to dealing with .dbf's so I
> find it difficult to get my head around this.
> Cheers
> Vic
>
>
>
> On Wed, 23 Mar 2005 09:06:38 +0100, Lars Broberg
> <lars.b@.elbe-data.nothing.se> wrote:
>
>
|||Lars,
Thank you very much..That puts my mind at rest considerably.
Cheers
Vic
On Wed, 23 Mar 2005 17:11:12 +0100, Lars Broberg
<lars.b@.elbe-data.nothing.se> wrote:
[vbcol=seagreen]
>Vic,
>They can use the same server. MSDE 2000 SP3a is installed as default
>without network support (DISABLENETWORKPROTOCOLS=1). You can change this
>when you install (set the parameter to zero) or you may use
>Network Utility to configure MSDE (use DbaMGR2k on the PC where you can
>connect to MSDE and look in the menu "Tools & Settings"):
>1.On the General tab, select the instance from the instance list (you
>probably only have one).
>2.Under Disabled protocols, click the protocol (such as TCP/IP)you want
>to enable, and then click Enable.
>3.Click OK.
>4.Stop and restart the service to make any changes take effect.
>If you have MSDE installed on a PC with Win XP/SP2, you have to manually
>open TCP/IP port 1433 in the XP firewall. For testing, you can just
>disable the firewall, but remember to activate it again...
>Lars Broberg
>Elbe-Data AB
>http://www.elbe-data.se
>Remove "nothing." when replying to private e-mail!
>
>Victor. d'Hoop wrote: