October 24, 2006 at 6:24 am
My application developed in delphi and is connected to sql-server 2000 database through ODBC and it is working fine. When I use replication between two servers and run the application it got hanged, I don't know why but when I debugging the application it stops at one stage where I'm openning the table..
could you pls suggest me the solution..
October 24, 2006 at 6:10 pm
how long does it stop for? what is happening when it stops? what type of replication are you using? If a new snapshot is being created, you might take a look at the job steps and see how long the tables are locked. I noticied recently that my database was "locked" for almost 12 minutes while all articles in one publication were snaped.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
October 26, 2006 at 3:12 pm
Yes, locked tables from snapshot replication is a likely cause. Or running a snapshot for a re-initialized transaction subscription. You can possibly adjust the timing of the various jobs involved. Also, if you have large tables in Snapshot replication, they might be better candidates for trans replication.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply