|
Removing rows on subscribers, but not on publishers
Hello.
I'm looking for a way to remove data from a merge replicated database
that would be filtered out if it was synchronized for the first time
today. In addition, I don't want the new rows to be deleted from the
publisher's database.
Let me explain. We have several tab ...
6 Jan 2005 13:24:56 -0800
|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:36:32 +0800
|
SQL Mobile and VS 2003
Good day,
Is it possible to access a SQL Mobile database on the device from a VS 2003
project?
Thx
Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com ...
Wed, 5 Jan 2005 10:29:13 -0800
|
error 80004005 28514 17
Hi,
i am trying to rda.pull a sqlserverce 2.0 from an app i created in c# on
pocket pc 2003.
When i try to pull i get these errors:
Error Code: 80004005
Message :
Minor Err.: 28574
Source : Microsoft SQL Server 2000 Windows CE Edition125950
Error Code: 80004005
Message : [DBNETLIB][Connecti ...
Tue, 4 Jan 2005 19:52:32 +0100
|
Can't insert plus-sign into ntext-field
I want to insert many phone numbers like '+4940-12345678' into a sqlce
ntext-field. The required field-size is about 1000 chars.
Caused by the '+' sign this gets replaced by some strange unicode
characters. (I don't need any unicode chars but need more than 255 chars)
How can i add a plus-sign followed by n ...
Tue, 4 Jan 2005 12:35:40 +0100
|
rda and batching
hi folks,
after some trials and tribulations i have "found" several things that have
given me some grief in my application design and i am wondering how people
have got round it.
my plan was to use rda to push data back to the sqlce database into a temp
table - which apparently worked fine. i used a trigger ...
Tue, 4 Jan 2005 10:13:58 -0000
|
Nullreferenceexception when creating replicaton object
Hi,
I have developed CF application that works with SQL CE 2.0 and uses
merge replication for synchronization.
Synchronization generally works OK, only sometimes I receive
Nullreferenceexception when I try to create replication object with
this line of code
Repl = New System.Data.SqlServerCe.SqlCeReplicatio ...
3 Jan 2005 08:08:15 -0800
|
Native error 25035 (Sharing violation)
Hi
im trying to close the connection, compact the database and open it again.
While doin so i got 2 errors
1)native error 28550 (cannot compact sql server ce)
2) Native error 25035 (Sharing violation)
Since i called Cdatasource::close() and Csession::close methods before i ran compact i assumed that we ...
Mon, 03 Jan 2005 14:27:28 GMT
|
Indexing - crucial?
Hi,
My 2nd question. I use a conveter (PocketSync) and it helps convert my MDB
(Access) to SQL CE, but without creating any indexes.
My concern is that, without indexes will the SQL CE operates slower? Very
much slower?
Also, how do you guys see and modify the data on SQL CE? I mean, other than
programm ...
Mon, 3 Jan 2005 16:24:09 +0800
|
Select within select
Hi,
Does SQL CE support this?
The following query failed at column 148 ("...FROM (SELECT CREATEDATE...")
If so, is there any work around?
----
"INSERT INTO COLLRPT (CREATEDATE, STORECODE, USERID, PRICE, STYPE) " & _
"SELECT TSAL.CREATEDATE, TSAL.STORECODE, TSAL.USERID, TSAL.TAMT, TSAL.SCODE
" & _
...
Mon, 3 Jan 2005 16:11:56 +0800
|
SQL CE Questions
We have could to test NorthwindDemoNet and all is ok. Following a list of questions to know certain capabilities of SQL CE Merge Replication:
We appreciatte your comments:
1. We read about that but we have little confusion yet:
1.1. Which are the cases by which we need to re-Publisher.
for instance: Add a n ...
Fri, 31 Dec 2004 18:00:24 GMT
|
SQL server does not exist or access denied - .net compact
I am developing an application for Pocket PC Mobile 2003. I am trying to connect to a sql server with the following connection parameters in vb.net compact framework:
Dim cn As SqlConnection
cn = New SqlConnection
cn.ConnectionString = "Data Source=192.168.1.109;database=TRAKSTAR;User
ID=TRAKSTAR ; passwor ...
Thu, 30 Dec 2004 15:41:27 -0800
|
DELL AXIM X30 SQCLE Query Analyzer Menu not showing
Help required, can't find mention of this bug anywhere.
I am trying to use the SQLCE (2.0) Query Analyzer on a DELL AXIM X30 Pocket PC [Intel PXA270; Windows Mobile 2003 Second Edition Version 4.21.1008(build14059)].
I am finding that the Tools & SQL menus are not being displayed, and that other icons on the ...
Wed, 29 Dec 2004 04:39:11 GMT
|
Anybody encount such exception ?
Hi everyone,
My CE application has the following symptom:
After the accessing to sqlce(actually, after update some records), while the
application destroy, the debug (under eVC 4.0) will report an exception
happened. It seems some resource could not be free.
Do you have any idea?
Thanks in advance.
...
Tue, 28 Dec 2004 17:07:30 +0800
|
Is the local SQL CE database essential?
I am a Newbie about SQL Server CE.
I wonder whether the local SQL CE database is essential to SQL Server
CE-base application?
Can we develop an CE-base application operating remote SQL Server 2000
directly?
Any help will be appreciated greatly.
...
Tue, 28 Dec 2004 14:43:41 +0800
|