Hello
i have a an application developed in vb6.0 and back end sql server 2000.
i have a batch file that i created to replicate the data from the sql server
2000 on my pc(local) to replicate on another sql server 2000 which is found
on another machine and the batch file is working fine.
i would like to implement it in my VB application.That is the user will
have a button on the program and on click this will do the replication that
is being done by the batch file for the moment.
i can call the batch file but we would like to do it by activeX.
Is there any activeX that already exist?
how can i do this by using activeX in VB6.0
If you need additional info please let me know..
Thx a lot
Nazeedah
try this:
http://www.indexserverfaq.com/replic...excontrols.zip
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nazeedah" <Nazeedah@.discussions.microsoft.com> wrote in message
news:53D7A4A9-EBEB-4F76-AF9B-5EF670EBC707@.microsoft.com...
> Hello
> i have a an application developed in vb6.0 and back end sql server 2000.
> i have a batch file that i created to replicate the data from the sql
> server
> 2000 on my pc(local) to replicate on another sql server 2000 which is
> found
> on another machine and the batch file is working fine.
> i would like to implement it in my VB application.That is the user will
> have a button on the program and on click this will do the replication
> that
> is being done by the batch file for the moment.
> i can call the batch file but we would like to do it by activeX.
> Is there any activeX that already exist?
> how can i do this by using activeX in VB6.0
> If you need additional info please let me know..
> Thx a lot
> Nazeedah
>
|||hello
Thank you for the link. its very interesting but i am bit lost in all the
code. could you please tell me which one is more specific in my case
Thank you a lot
"Nazeedah" wrote:
> Hello
> i have a an application developed in vb6.0 and back end sql server 2000.
> i have a batch file that i created to replicate the data from the sql server
> 2000 on my pc(local) to replicate on another sql server 2000 which is found
> on another machine and the batch file is working fine.
> i would like to implement it in my VB application.That is the user will
> have a button on the program and on click this will do the replication that
> is being done by the batch file for the moment.
> i can call the batch file but we would like to do it by activeX.
> Is there any activeX that already exist?
> how can i do this by using activeX in VB6.0
> If you need additional info please let me know..
> Thx a lot
> Nazeedah
>
|||its code sample 5
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nazeedah" <Nazeedah@.discussions.microsoft.com> wrote in message
news:BEC8AF2F-7EEB-4AF4-B269-7BDF5917BEA7@.microsoft.com...[vbcol=seagreen]
> hello
> Thank you for the link. its very interesting but i am bit lost in all the
> code. could you please tell me which one is more specific in my case
> Thank you a lot
> "Nazeedah" wrote:
sql
Showing posts with label back. Show all posts
Showing posts with label back. Show all posts
Friday, March 30, 2012
Saturday, February 25, 2012
Replication Loop Back Detection Problems in SQL Server 2000
Hi,
I am monitoring my replication process and I have a problem with the loop detection, I can see origined transacctions in the server, executed in the same for the replication.
The subscriptions configuration is sp_helpsubscription
exec sp_addsubscription @.publication = N'PUBLICATION',
@.article = N'all',
@.subscriber = N'192.168.0.23',
@.destination_db = N'PRUEBABD',
@.sync_type = N'none',
@.update_mode = N'read only',
@.offloadagent = 0,
@.dts_package_location = N'distributor',
@.loopback_detection = 'true'
GO
I need for help.
Sorry, it's not clear to me what the problem is. Are you getting an error of some sort?|||Yes, I have loops in the replication between the subscribers and too many deadlocks.
My topology is
Server A replicates to Server P,
the Server P replicates to Server A,
Server B replicates to Server P and
the Server P replicates to Server B.
I am using transactional replication,
|||sorry, i'm still not clear. what exactly is the error. if it's deadlock, what statements are deadlocking?|||My problem is that loop back detection is unless when I registed the subscriptions with IP. The publicator servers are registered for name.Replication Job Failed. Unable to determine the owner
A former employee at my organization created a replication job to back up our database. The developer has since left and his windows account was deleted. I'm now receiving this error:
SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-05 15:40:00 - Message: The job failed. Unable to determine if the owner (username) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'username', error code 0x534. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
How can I fix this? I looked under the Replication folder but didn't see anything.
In Object Explorer, look at the job in SQL Server Agent to see who owns it, and verify the account is valid.
|||That's for the help. I changed the owner but am now getting this error:SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-07 01:00:00 - Message: The job failed. The Job was invoked by Schedule 175 (Replication agent schedule.). The last step to run was step 1 (Run agent.).
When I executed the maintenance plan manually it worked, but it doesn't seem to work on the schedule. I've never created a maintenance plans so I'm going to look up some more information to see if I can figure out what is going to wrong.
Replication Job Failed. Unable to determine the owner
A former employee at my organization created a replication job to back up our database. The developer has since left and his windows account was deleted. I'm now receiving this error:
SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-05 15:40:00 - Message: The job failed. Unable to determine if the owner (username) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'username', error code 0x534. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
How can I fix this? I looked under the Replication folder but didn't see anything.
In Object Explorer, look at the job in SQL Server Agent to see who owns it, and verify the account is valid.
|||That's for the help. I changed the owner but am now getting this error:SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-07 01:00:00 - Message: The job failed. The Job was invoked by Schedule 175 (Replication agent schedule.). The last step to run was step 1 (Run agent.).
When I executed the maintenance plan manually it worked, but it doesn't seem to work on the schedule. I've never created a maintenance plans so I'm going to look up some more information to see if I can figure out what is going to wrong.
Tuesday, February 21, 2012
replication is completed
We have a server that is replicating information back and forth to 10
different location. My question is how do i know if a location is done
replicating to us. my scenario is that we have 10 stores, each stores as it
makes a sales, the information is replicated back to corporate. Corporate
in turn replicate that information back to the other nine stores. How can i
tell if a store is done downloading information to corporate verse corporate
still trying to push data to the store.
tx in advance.
That depends. Is there ever a point when no transactions are occuring on the
stores? If so you can schedule the agents and after the final job has
completed the central location will have all the data.
Another option is to run sp_browsereplcmds on the publisher and subscriber
until no rows are returned.
You could also query select delivered_transactions from
MSdistribution_history in the distribution database and wait for a value of
delivered_transactions to be 0.
For merge you might want to query select delivery_rate from
MSmerge_history
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"tlee" <tlee@.lang.com> wrote in message
news:OVTyEXXsEHA.904@.TK2MSFTNGP11.phx.gbl...
> We have a server that is replicating information back and forth to 10
> different location. My question is how do i know if a location is done
> replicating to us. my scenario is that we have 10 stores, each stores as
it
> makes a sales, the information is replicated back to corporate. Corporate
> in turn replicate that information back to the other nine stores. How can
i
> tell if a store is done downloading information to corporate verse
corporate
> still trying to push data to the store.
> tx in advance.
>
|||Thanks, i will give it a try.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23C$IATesEHA.3320@.TK2MSFTNGP15.phx.gbl...
> That depends. Is there ever a point when no transactions are occuring on
> the
> stores? If so you can schedule the agents and after the final job has
> completed the central location will have all the data.
> Another option is to run sp_browsereplcmds on the publisher and subscriber
> until no rows are returned.
> You could also query select delivered_transactions from
> MSdistribution_history in the distribution database and wait for a value
> of
> delivered_transactions to be 0.
> For merge you might want to query select delivery_rate from
> MSmerge_history
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "tlee" <tlee@.lang.com> wrote in message
> news:OVTyEXXsEHA.904@.TK2MSFTNGP11.phx.gbl...
> it
> i
> corporate
>
different location. My question is how do i know if a location is done
replicating to us. my scenario is that we have 10 stores, each stores as it
makes a sales, the information is replicated back to corporate. Corporate
in turn replicate that information back to the other nine stores. How can i
tell if a store is done downloading information to corporate verse corporate
still trying to push data to the store.
tx in advance.
That depends. Is there ever a point when no transactions are occuring on the
stores? If so you can schedule the agents and after the final job has
completed the central location will have all the data.
Another option is to run sp_browsereplcmds on the publisher and subscriber
until no rows are returned.
You could also query select delivered_transactions from
MSdistribution_history in the distribution database and wait for a value of
delivered_transactions to be 0.
For merge you might want to query select delivery_rate from
MSmerge_history
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"tlee" <tlee@.lang.com> wrote in message
news:OVTyEXXsEHA.904@.TK2MSFTNGP11.phx.gbl...
> We have a server that is replicating information back and forth to 10
> different location. My question is how do i know if a location is done
> replicating to us. my scenario is that we have 10 stores, each stores as
it
> makes a sales, the information is replicated back to corporate. Corporate
> in turn replicate that information back to the other nine stores. How can
i
> tell if a store is done downloading information to corporate verse
corporate
> still trying to push data to the store.
> tx in advance.
>
|||Thanks, i will give it a try.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23C$IATesEHA.3320@.TK2MSFTNGP15.phx.gbl...
> That depends. Is there ever a point when no transactions are occuring on
> the
> stores? If so you can schedule the agents and after the final job has
> completed the central location will have all the data.
> Another option is to run sp_browsereplcmds on the publisher and subscriber
> until no rows are returned.
> You could also query select delivered_transactions from
> MSdistribution_history in the distribution database and wait for a value
> of
> delivered_transactions to be 0.
> For merge you might want to query select delivery_rate from
> MSmerge_history
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "tlee" <tlee@.lang.com> wrote in message
> news:OVTyEXXsEHA.904@.TK2MSFTNGP11.phx.gbl...
> it
> i
> corporate
>
Subscribe to:
Posts (Atom)