I am trying to replicate a database but it seems to go into endless
loop showing:
Processing article: 'Table1'
Processing article: 'Table2'
Processing article: 'Table3'
Processing article: 'Table1'
Processing article: 'Table2'
..
..
..
I stopped it after quite a lot of loop cycles, but it looks like it is
still running in background. In enterprise manager the last action is
"Synchronization in progress" and status is "Running". I already
restarted the sql-server service and also the computer - didn't help.
The replication is done using an external program and not with job.
Thanks
This can be normal. You should let this process finish. It is somewhat
transactional, ie it will pick up where it left off.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"or dromi" <or_dromi@.walla.co.il> wrote in message
news:539934ef.0411240754.37ab924a@.posting.google.c om...
>I am trying to replicate a database but it seems to go into endless
> loop showing:
> Processing article: 'Table1'
> Processing article: 'Table2'
> Processing article: 'Table3'
> Processing article: 'Table1'
> Processing article: 'Table2'
> .
> .
> .
> I stopped it after quite a lot of loop cycles, but it looks like it is
> still running in background. In enterprise manager the last action is
> "Synchronization in progress" and status is "Running". I already
> restarted the sql-server service and also the computer - didn't help.
> The replication is done using an external program and not with job.
>
> Thanks
sql
Showing posts with label replicate. Show all posts
Showing posts with label replicate. Show all posts
Thursday, March 29, 2012
Friday, March 9, 2012
Encription of a column
I need to replicate some Oracle functionality that allows
a text column to be encripted in the database and
decripted by a JSP web application. Anyone have any
suggestions on how to go about this?You can find several third party products that have encryption options
listed in the Encryption section of the faq at:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
-Sue
On Thu, 10 Jun 2004 09:21:55 -0700, "Amy Thropp"
<athropp@.thinksmartps.com> wrote:
>I need to replicate some Oracle functionality that allows
>a text column to be encripted in the database and
>decripted by a JSP web application. Anyone have any
>suggestions on how to go about this?|||SQL Server 2000 does not natively support in-database cryptographic
operations. It has been announced by Microsoft that SQL Server 2005 will
support encryption and key management. One article that reports on this
announcement can be found @.
http://www.internetnews.com/dev-new...cle.php/3358991
Mark Shlimovich
"Amy Thropp" <athropp@.thinksmartps.com> wrote in message
news:239401c44f07$0bb652c0$7d02280a@.phx.gbl...
> I need to replicate some Oracle functionality that allows
> a text column to be encripted in the database and
> decripted by a JSP web application. Anyone have any
> suggestions on how to go about this?|||Have a look at
www.whamware.com - Whamware.Crypt
www.appsecinc.com - dbEncrypt
www.netlib.com - Encryptionizer for SQL Server
Tom
"Amy Thropp" wrote:
> I need to replicate some Oracle functionality that allows
> a text column to be encripted in the database and
> decripted by a JSP web application. Anyone have any
> suggestions on how to go about this?|||www.xpcrypt.com
a text column to be encripted in the database and
decripted by a JSP web application. Anyone have any
suggestions on how to go about this?You can find several third party products that have encryption options
listed in the Encryption section of the faq at:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
-Sue
On Thu, 10 Jun 2004 09:21:55 -0700, "Amy Thropp"
<athropp@.thinksmartps.com> wrote:
>I need to replicate some Oracle functionality that allows
>a text column to be encripted in the database and
>decripted by a JSP web application. Anyone have any
>suggestions on how to go about this?|||SQL Server 2000 does not natively support in-database cryptographic
operations. It has been announced by Microsoft that SQL Server 2005 will
support encryption and key management. One article that reports on this
announcement can be found @.
http://www.internetnews.com/dev-new...cle.php/3358991
Mark Shlimovich
"Amy Thropp" <athropp@.thinksmartps.com> wrote in message
news:239401c44f07$0bb652c0$7d02280a@.phx.gbl...
> I need to replicate some Oracle functionality that allows
> a text column to be encripted in the database and
> decripted by a JSP web application. Anyone have any
> suggestions on how to go about this?|||Have a look at
www.whamware.com - Whamware.Crypt
www.appsecinc.com - dbEncrypt
www.netlib.com - Encryptionizer for SQL Server
Tom
"Amy Thropp" wrote:
> I need to replicate some Oracle functionality that allows
> a text column to be encripted in the database and
> decripted by a JSP web application. Anyone have any
> suggestions on how to go about this?|||www.xpcrypt.com
Sunday, February 19, 2012
Emulator Error to replicate data on SQL server
Hi Guys,
I've tried to make Microsoft lab to create a DB(SQL sever CE) on emulator by existing one on SQL Server,but i've a problem :
when i use moethod(of object SqlCeReplication) to make replicate data, emulator send error -2147012867(A connection with the IIS server could not be established)
may you help me,please ?
thx,bye.
Can you connect to IIS virtual directory from emulator? ( http://Computer_name/virtualdirectory/sqlce30.dll ) . You should see a message SQL Server .. Server Agent.
? If you can’t access this, it meant that connection from device/emulator to IIS is broken.
? If you can access this, it meant that there is issue in getting connected /access permission etc from IIS to SQL Server/Publication.
The account you are using for IIS needs to have access on snapshot. If you are using anonymous use IUSR_Computername
Please ensure to give access rights to \\COMPUTER\repldata
check status of snapshot
Select Replicationà Local publicationàpublication you created.
Right click and check the status of snap shot. (Click start if its status was failure)
but,now i've another problem :
i see server agent message,but i use another way ( http://Computer_name/virtualdirectory/sscesa20.dll ).
When i start appl the same method give me another exception :
"Header information is either corrupted or missing)"
remember,i'm using pocket pc emulator 2003 under VS 2005 beta.
thx for all.
|||
Please excuse us for the late reply.
Here is what my understanding:
1) You are having SQL CE 2.0 Server components on IIS
2) Did you choose Dev App v 1.0 on VS 2005 for the project? I guess you have chosen Dev App (which is SQL CE 3.0 Client). And that is why this error!!
Ok here are the things we want to know to make this proceed further:
1) What is SQL Server version. SQL Server 2000/8.0 or SQL Server 2005/9.0?
2) Where is IIS machine. Same as SQL Server machine or different
3) What is installed on IIS Machine for Replication to work and what versions
The error message generally comes when you have different versions of components in different places.
Also, do you really want to work SQL Server CE 2.0 Client & Server. It is an old version. And, the current version of SQL CE is 3.0. Please consider the option of switching to SQL CE/Mobile 3.0. SQL Mobile 3.0 works very well on Pocket PC 2003. For this you need to choose Dev App.
Hope this helps!
Thanks,
Laxmi NRO, MSFT, SQL Mobile
HI,
I am trying to use RDA replication to synchoronize the sql ce 2.0 to SQL 2000 in the desktop in Real PDA..i am getting an error that Header information is missing or corrupted .i am putting my source code below..plzz help me ..its very urgent.
Dim strDBFile As String = "\temp\login.sdf"
_repl.InternetUrl = "http://ihsan/SqlCE/sscesa20.dll"
_repl.Publisher = "IHSAN"
_repl.PublisherLogin = "sa"
_repl.PublisherPassword = "sa"
_repl.PublisherSecurityMode = SecurityType.DBAuthentication
_repl.Publication = "SYNCPDA"
_repl.PublisherDatabase = "SYNCPDA"
_repl.SubscriberConnectionString = "data source=\Temp\login.sdf"
_repl.Subscriber = "SYNCPDA"
If Not System.IO.File.Exists(strDBFile) Then
MessageBox.Show("La aplicacion requiere sincronización" & Microsoft.VisualBasic.Chr(13) & "" & Microsoft.VisualBasic.Chr(10) & "Por favor aguarde", "Replicator", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)
_repl.AddSubscription(AddOption.CreateDatabase)
' sync()
Else
Try
_repl.Synchronize()
Catch ex As Exception
MsgBox(ex.Message)
MsgBox(ex.GetHashCode())
End Try
|||Are you using a firewall on your desktop, ie Norton. Then see this blog for info: http://dotnetjunkies.com/WebLog/darrenshaffer/archive/2005/12/07/134186.aspx
|||
HI ,
Thanks a lot for your reply,i disabled everyting stiil giving the same error..wat should i do .
Thanks in advance
Regards
Ihsan
Emulator Error to replicate data on SQL server
Hi Guys,
I've tried to make Microsoft lab to create a DB(SQL sever CE) on emulator by existing one on SQL Server,but i've a problem :
when i use moethod(of object SqlCeReplication) to make replicate data, emulator send error -2147012867(A connection with the IIS server could not be established)
may you help me,please ?
thx,bye.
Can you connect to IIS virtual directory from emulator? ( http://Computer_name/virtualdirectory/sqlce30.dll ) . You should see a message SQL Server .. Server Agent.
? If you can’t access this, it meant that connection from device/emulator to IIS is broken.
? If you can access this, it meant that there is issue in getting connected /access permission etc from IIS to SQL Server/Publication.
The account you are using for IIS needs to have access on snapshot. If you are using anonymous use IUSR_Computername
Please ensure to give access rights to \\COMPUTER\repldata
check status of snapshot
Select Replicationà Local publicationàpublication you created.
Right click and check the status of snap shot. (Click start if its status was failure)
but,now i've another problem :
i see server agent message,but i use another way ( http://Computer_name/virtualdirectory/sscesa20.dll ).
When i start appl the same method give me another exception :
"Header information is either corrupted or missing)"
remember,i'm using pocket pc emulator 2003 under VS 2005 beta.
thx for all.
|||
Please excuse us for the late reply.
Here is what my understanding:
1) You are having SQL CE 2.0 Server components on IIS
2) Did you choose Dev App v 1.0 on VS 2005 for the project? I guess you have chosen Dev App (which is SQL CE 3.0 Client). And that is why this error!!
Ok here are the things we want to know to make this proceed further:
1) What is SQL Server version. SQL Server 2000/8.0 or SQL Server 2005/9.0?
2) Where is IIS machine. Same as SQL Server machine or different
3) What is installed on IIS Machine for Replication to work and what versions
The error message generally comes when you have different versions of components in different places.
Also, do you really want to work SQL Server CE 2.0 Client & Server. It is an old version. And, the current version of SQL CE is 3.0. Please consider the option of switching to SQL CE/Mobile 3.0. SQL Mobile 3.0 works very well on Pocket PC 2003. For this you need to choose Dev App.
Hope this helps!
Thanks,
Laxmi NRO, MSFT, SQL Mobile
HI,
I am trying to use RDA replication to synchoronize the sql ce 2.0 to SQL 2000 in the desktop in Real PDA..i am getting an error that Header information is missing or corrupted .i am putting my source code below..plzz help me ..its very urgent.
Dim strDBFile As String = "\temp\login.sdf"
_repl.InternetUrl = "http://ihsan/SqlCE/sscesa20.dll"
_repl.Publisher = "IHSAN"
_repl.PublisherLogin = "sa"
_repl.PublisherPassword = "sa"
_repl.PublisherSecurityMode = SecurityType.DBAuthentication
_repl.Publication = "SYNCPDA"
_repl.PublisherDatabase = "SYNCPDA"
_repl.SubscriberConnectionString = "data source=\Temp\login.sdf"
_repl.Subscriber = "SYNCPDA"
If Not System.IO.File.Exists(strDBFile) Then
MessageBox.Show("La aplicacion requiere sincronización" & Microsoft.VisualBasic.Chr(13) & "" & Microsoft.VisualBasic.Chr(10) & "Por favor aguarde", "Replicator", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)
_repl.AddSubscription(AddOption.CreateDatabase)
' sync()
Else
Try
_repl.Synchronize()
Catch ex As Exception
MsgBox(ex.Message)
MsgBox(ex.GetHashCode())
End Try
|||Are you using a firewall on your desktop, ie Norton. Then see this blog for info: http://dotnetjunkies.com/WebLog/darrenshaffer/archive/2005/12/07/134186.aspx
|||HI ,
Thanks a lot for your reply,i disabled everyting stiil giving the same error..wat should i do .
Thanks in advance
Regards
Ihsan
Subscribe to:
Posts (Atom)