bidirectionnal connection fro merge replication?

Hello, I only need to know if I need to have a bidirectionnal connection between the subscriber and the publisher for merge replication or if the connection ca be openned only from the publisher to the subscriber if i use the push subscription option.
Thanks in advanceIn a push merge replication scenario you still need to ensure that there is a communication going when new transactions are posted on the subscriber(-s)'s side.

best way to tolerate an unreliable WAN connection?

I'm looking at a problem two sites have - the both run the same ERP system
on one server, and their WAN and internet connections are unreliable. What
is the preferred method to keep people from sitting on their thumbs when the
WAN is unavailable? What about if you want to be able to change data at both
locations while the connection is down?
Paul
I would cehck with the ERP vendor to see if they support
replication...either through SQL Server or through their own processes.
Many ERP/CRM vendors do have a "remote server" concept built-in for just
such a situation
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <noone@.executespammers.org> wrote in message
news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> I'm looking at a problem two sites have - the both run the same ERP system
> on one server, and their WAN and internet connections are unreliable. What
> is the preferred method to keep people from sitting on their thumbs when
> the
> WAN is unavailable? What about if you want to be able to change data at
> both
> locations while the connection is down?
> Paul
>
|||I messed with replication while back. It made making changes to the database
(new columns, SP's etc) a pain. I was hoping there might be an alternative,
maybe a third-party product.
The ERP system is a custom one. I'm trying to find a solution for a problem
my friend is having. Definitely anything he settles on to fix it would be of
interest to me, because I do custom ERP systems as well. We're fortunate
enough here though where WAN downtime hasn't been an issue thus far.
Paul
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:u6VabyujFHA.2852@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> I would cehck with the ERP vendor to see if they support
> replication...either through SQL Server or through their own processes.
> Many ERP/CRM vendors do have a "remote server" concept built-in for just
> such a situation
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul" <noone@.executespammers.org> wrote in message
> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
system[vbcol=seagreen]
What
>
|||If you want the system usable in two places that are not connected (during a
WAN outage), you are definitely looking into replication. Unless one of the
systems is going to be read-only. In that case you may be able to look into
log shipping, or 3rd party products like double-take from
www.nsisoftware.com (no affiliation)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <noone@.executespammers.org> wrote in message
news:%231ALn%23ujFHA.3348@.tk2msftngp13.phx.gbl...
>I messed with replication while back. It made making changes to the
>database
> (new columns, SP's etc) a pain. I was hoping there might be an
> alternative,
> maybe a third-party product.
> The ERP system is a custom one. I'm trying to find a solution for a
> problem
> my friend is having. Definitely anything he settles on to fix it would be
> of
> interest to me, because I do custom ERP systems as well. We're fortunate
> enough here though where WAN downtime hasn't been an issue thus far.
> Paul
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:u6VabyujFHA.2852@.TK2MSFTNGP15.phx.gbl...
> system
> What
>
|||Hi
Why not get the network sorted out. If the WAN goes down, hit ISDN/Dial Up
and keep the location working.
Implementing workarounds because the network guys can't keep their act
together is a difficult and costly thing.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul" <noone@.executespammers.org> wrote in message
news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> I'm looking at a problem two sites have - the both run the same ERP system
> on one server, and their WAN and internet connections are unreliable. What
> is the preferred method to keep people from sitting on their thumbs when
> the
> WAN is unavailable? What about if you want to be able to change data at
> both
> locations while the connection is down?
> Paul
>
|||Yeah, that's the advice I gave.
According to the guy suffering from this, one site is out in the sticks and
has only Verizon for a provider and (apparently) one option for
connectivity. I told him to try to set up a failover connection over a
regular cable broadband connection. Never seen it done, but I don't see why
it couldn't work. People may turn their noses up at residential connections
but it's better than nothing, and some of them are damn fast. I've been
looking at Verizon's FIOS and salivating. 30Mb/s!
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u8tKsY3jFHA.3144@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi
> Why not get the network sorted out. If the WAN goes down, hit ISDN/Dial Up
> and keep the location working.
> Implementing workarounds because the network guys can't keep their act
> together is a difficult and costly thing.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul" <noone@.executespammers.org> wrote in message
> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
system[vbcol=seagreen]
What
>

best way to tolerate an unreliable WAN connection?

I'm looking at a problem two sites have - the both run the same ERP system
on one server, and their WAN and internet connections are unreliable. What
is the preferred method to keep people from sitting on their thumbs when the
WAN is unavailable? What about if you want to be able to change data at both
locations while the connection is down?
PaulI would cehck with the ERP vendor to see if they support
replication...either through SQL Server or through their own processes.
Many ERP/CRM vendors do have a "remote server" concept built-in for just
such a situation
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <noone@.executespammers.org> wrote in message
news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> I'm looking at a problem two sites have - the both run the same ERP system
> on one server, and their WAN and internet connections are unreliable. What
> is the preferred method to keep people from sitting on their thumbs when
> the
> WAN is unavailable? What about if you want to be able to change data at
> both
> locations while the connection is down?
> Paul
>|||I messed with replication while back. It made making changes to the database
(new columns, SP's etc) a pain. I was hoping there might be an alternative,
maybe a third-party product.
The ERP system is a custom one. I'm trying to find a solution for a problem
my friend is having. Definitely anything he settles on to fix it would be of
interest to me, because I do custom ERP systems as well. We're fortunate
enough here though where WAN downtime hasn't been an issue thus far.
Paul
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:u6VabyujFHA.2852@.TK2MSFTNGP15.phx.gbl...
> I would cehck with the ERP vendor to see if they support
> replication...either through SQL Server or through their own processes.
> Many ERP/CRM vendors do have a "remote server" concept built-in for just
> such a situation
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul" <noone@.executespammers.org> wrote in message
> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
system[vbcol=seagreen]
What[vbcol=seagreen]
>|||If you want the system usable in two places that are not connected (during a
WAN outage), you are definitely looking into replication. Unless one of the
systems is going to be read-only. In that case you may be able to look into
log shipping, or 3rd party products like double-take from
www.nsisoftware.com (no affiliation)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <noone@.executespammers.org> wrote in message
news:%231ALn%23ujFHA.3348@.tk2msftngp13.phx.gbl...
>I messed with replication while back. It made making changes to the
>database
> (new columns, SP's etc) a pain. I was hoping there might be an
> alternative,
> maybe a third-party product.
> The ERP system is a custom one. I'm trying to find a solution for a
> problem
> my friend is having. Definitely anything he settles on to fix it would be
> of
> interest to me, because I do custom ERP systems as well. We're fortunate
> enough here though where WAN downtime hasn't been an issue thus far.
> Paul
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:u6VabyujFHA.2852@.TK2MSFTNGP15.phx.gbl...
> system
> What
>|||Hi
Why not get the network sorted out. If the WAN goes down, hit ISDN/Dial Up
and keep the location working.
Implementing workarounds because the network guys can't keep their act
together is a difficult and costly thing.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul" <noone@.executespammers.org> wrote in message
news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> I'm looking at a problem two sites have - the both run the same ERP system
> on one server, and their WAN and internet connections are unreliable. What
> is the preferred method to keep people from sitting on their thumbs when
> the
> WAN is unavailable? What about if you want to be able to change data at
> both
> locations while the connection is down?
> Paul
>|||Yeah, that's the advice I gave.
According to the guy suffering from this, one site is out in the sticks and
has only Verizon for a provider and (apparently) one option for
connectivity. I told him to try to set up a failover connection over a
regular cable broadband connection. Never seen it done, but I don't see why
it couldn't work. People may turn their noses up at residential connections
but it's better than nothing, and some of them are damn fast. I've been
looking at Verizon's FIOS and salivating. 30Mb/s!
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u8tKsY3jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> Hi
> Why not get the network sorted out. If the WAN goes down, hit ISDN/Dial Up
> and keep the location working.
> Implementing workarounds because the network guys can't keep their act
> together is a difficult and costly thing.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul" <noone@.executespammers.org> wrote in message
> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
system[vbcol=seagreen]
What[vbcol=seagreen]
>

best way to tolerate an unreliable WAN connection?

I'm looking at a problem two sites have - the both run the same ERP system
on one server, and their WAN and internet connections are unreliable. What
is the preferred method to keep people from sitting on their thumbs when the
WAN is unavailable? What about if you want to be able to change data at both
locations while the connection is down?
PaulI would cehck with the ERP vendor to see if they support
replication...either through SQL Server or through their own processes.
Many ERP/CRM vendors do have a "remote server" concept built-in for just
such a situation
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <noone@.executespammers.org> wrote in message
news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> I'm looking at a problem two sites have - the both run the same ERP system
> on one server, and their WAN and internet connections are unreliable. What
> is the preferred method to keep people from sitting on their thumbs when
> the
> WAN is unavailable? What about if you want to be able to change data at
> both
> locations while the connection is down?
> Paul
>|||I messed with replication while back. It made making changes to the database
(new columns, SP's etc) a pain. I was hoping there might be an alternative,
maybe a third-party product.
The ERP system is a custom one. I'm trying to find a solution for a problem
my friend is having. Definitely anything he settles on to fix it would be of
interest to me, because I do custom ERP systems as well. We're fortunate
enough here though where WAN downtime hasn't been an issue thus far.
Paul
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:u6VabyujFHA.2852@.TK2MSFTNGP15.phx.gbl...
> I would cehck with the ERP vendor to see if they support
> replication...either through SQL Server or through their own processes.
> Many ERP/CRM vendors do have a "remote server" concept built-in for just
> such a situation
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul" <noone@.executespammers.org> wrote in message
> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> > I'm looking at a problem two sites have - the both run the same ERP
system
> > on one server, and their WAN and internet connections are unreliable.
What
> > is the preferred method to keep people from sitting on their thumbs when
> > the
> > WAN is unavailable? What about if you want to be able to change data at
> > both
> > locations while the connection is down?
> >
> > Paul
> >
> >
>|||If you want the system usable in two places that are not connected (during a
WAN outage), you are definitely looking into replication. Unless one of the
systems is going to be read-only. In that case you may be able to look into
log shipping, or 3rd party products like double-take from
www.nsisoftware.com (no affiliation)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <noone@.executespammers.org> wrote in message
news:%231ALn%23ujFHA.3348@.tk2msftngp13.phx.gbl...
>I messed with replication while back. It made making changes to the
>database
> (new columns, SP's etc) a pain. I was hoping there might be an
> alternative,
> maybe a third-party product.
> The ERP system is a custom one. I'm trying to find a solution for a
> problem
> my friend is having. Definitely anything he settles on to fix it would be
> of
> interest to me, because I do custom ERP systems as well. We're fortunate
> enough here though where WAN downtime hasn't been an issue thus far.
> Paul
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:u6VabyujFHA.2852@.TK2MSFTNGP15.phx.gbl...
>> I would cehck with the ERP vendor to see if they support
>> replication...either through SQL Server or through their own processes.
>> Many ERP/CRM vendors do have a "remote server" concept built-in for just
>> such a situation
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Paul" <noone@.executespammers.org> wrote in message
>> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
>> > I'm looking at a problem two sites have - the both run the same ERP
> system
>> > on one server, and their WAN and internet connections are unreliable.
> What
>> > is the preferred method to keep people from sitting on their thumbs
>> > when
>> > the
>> > WAN is unavailable? What about if you want to be able to change data at
>> > both
>> > locations while the connection is down?
>> >
>> > Paul
>> >
>> >
>>
>|||Hi
Why not get the network sorted out. If the WAN goes down, hit ISDN/Dial Up
and keep the location working.
Implementing workarounds because the network guys can't keep their act
together is a difficult and costly thing.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul" <noone@.executespammers.org> wrote in message
news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> I'm looking at a problem two sites have - the both run the same ERP system
> on one server, and their WAN and internet connections are unreliable. What
> is the preferred method to keep people from sitting on their thumbs when
> the
> WAN is unavailable? What about if you want to be able to change data at
> both
> locations while the connection is down?
> Paul
>|||Yeah, that's the advice I gave.
According to the guy suffering from this, one site is out in the sticks and
has only Verizon for a provider and (apparently) one option for
connectivity. I told him to try to set up a failover connection over a
regular cable broadband connection. Never seen it done, but I don't see why
it couldn't work. People may turn their noses up at residential connections
but it's better than nothing, and some of them are damn fast. I've been
looking at Verizon's FIOS and salivating. 30Mb/s!
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u8tKsY3jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> Hi
> Why not get the network sorted out. If the WAN goes down, hit ISDN/Dial Up
> and keep the location working.
> Implementing workarounds because the network guys can't keep their act
> together is a difficult and costly thing.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul" <noone@.executespammers.org> wrote in message
> news:OhI52pujFHA.3288@.TK2MSFTNGP09.phx.gbl...
> > I'm looking at a problem two sites have - the both run the same ERP
system
> > on one server, and their WAN and internet connections are unreliable.
What
> > is the preferred method to keep people from sitting on their thumbs when
> > the
> > WAN is unavailable? What about if you want to be able to change data at
> > both
> > locations while the connection is down?
> >
> > Paul
> >
> >
>

Best way to pervent unused and left open connection to sql

Hello every one i had a design question.

What would be the best way to approach a problem such as a perventing unsed and left open sql connections

i have written a class called DataBase Manger but my question is should this class be static or none-static. right now the way i have is something like this

private SqlConnection Get() {
SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["StringConnetionName"].ConnectionString);
sqlCon.Open();
return sqlCon;
}

/// <summary>
/// Closes a connection to the Database
/// </summary>
/// <param name="sqlCon"> Database connection to close</param>
private void Let(SqlConnection sqlCon) {
sqlCon.Close();
sqlCon = null;
}

then for example to run a store proc i have

public int RunProc(string procName,params SqlParameter[] p) { SqlConnection con = Get();try {using (SqlCommand cmd = CreateCommand(con, procName, p)) { cmd.ExecuteNonQuery();return (int)cmd.Parameters["ReturnValue"].Value; } }finally { Let(con); } }

now every time in any class or method i need to create a new Database manager and call the run proc object. Would it be a better desing to make this class static? so it would be just

DataBaseManger.RunProc(blah,blah)

or is it a better OO design to have it the way i have it. is is more secure in a webapplication? can these connections be hijacked?

thanks in adanvce, any help would greatly be apperiated. or any link to any related tutorials

thanks,

Amir

if you consider the design of the old MS Data Access Application Block (SqlHelper), you will see that virtually all the methods are static methods.

This is a very convenient approach and works well.

Rather than reinvent the wheel, why not look at incorporating the new data access application block from the enterprise library?

Best way to connect to a MSSQL database

Hello,

Is it better to use a DSN connection or using a connection string Set Connection = Server.CreateObject("ADODB.Connection")

Which is easier to use and more reliable?

Also could I have all the connection info on one page and then just include it with a include statment everytime I need to query the database??

Thank you,

Rich

Are you using classic ASP or ASP.NET? The first has pages ending in .asp, and the second ends with .aspx.

In either case, DSNs and ODBC are discouraged.

For Sql Server 2000, look here:http://www.connectionstrings.com/?carrier=sqlserver, and for 2005, here:http://www.connectionstrings.com/?carrier=sqlserver2005

|||

I am learning classic ASP and then will learn ASP.NET

Why are DSNs and ODBC discouraged...

I was looking at the websites you gave me.. then are all saying .NET... will classic ASP work too??

Rich

|||

for Classic ASP i would recommend using DSN and ODBC as you can use any database with this kind of connections with smaller changes.

you can place your connection in a page called connection.asp which then you will need to inlcude at the top of each page. for sample check out this:

http://www.codeproject.com/database/connectionstrings.asp

but for ASP.NET its provides its own Provider for different database which makes its easy to control the database and are faster and more releiable then ODBC.

thanks

|||

Frankly, I would go straight to ASP.NET. It has replaced classic ASP. There's a newsgroup for classic ASP over at microsoft.public.inetserver.asp.general (which you can get to through Google Groups). There used to be thousands of posts a month there. No there are just one or two per day. Classic ASP will not be developed any further. The only reason that people generally use it these days is because they have existing apps that were written in classic ASP that they want to maintain.

ODBC is deprecated technology. DSNs make use of ODBC. They cause unnecessary overhead and maintenance. For classic ASP, you should use OLEDB.

http://databases.aspfaq.com/database/what-should-my-connection-string-look-like.html