Concurrent database access in SQL 2005 Mobile
Wed, 23 Jul 2008 11:14:01 -0700
Hello all... I'm having a very annoying issue that's about to make me crazy.
I have a database application developed with VS2005 and OLEDB access to a
SQL 2005 Mobile database. While the application is running the same database
can be accessed by another notifying application that shoud add, modify or
dele ...
|
error while editing a table schema
Wed, 23 Jul 2008 10:31:01 -0400
Hi all,
I have tried to change a table schema, but every time I am getting the
attached error
message. I thought that I had a connection to the database but I made sure
that there
were no connections. Can someone help?
Thanks,
Carlos.
...
|
Help: dupe param error with SqlCeCommand:
Wed, 23 Jul 2008 07:20:27 -0700
Argh! I am getting "duplicate parameter" errors with the following
prepared SqlCeCommand: (The important line is the next to the last line
with @kid_id).
select e.entry_id,
convert(nvarchar(10), e.entry_date, 101),
e.entry_title,
e.entry_text,
e.minutes_spent,
e.entry_date
from ud_ent ...
|
Renaming a Table in SQLCE
Wed, 23 Jul 2008 12:57:45 +0530
Hello,
I have a situation where I need to implement a custom synchronization
mechanism between SQL CE and SQL Server 2005 using RDA.
One method that I thought of implementing was to rename tables so that the
data could be recovered in case of network errors or failures.
But on researching I found that r ...
|
data source configuration
Tue, 22 Jul 2008 07:19:12 -0700
How can I set this property so it works easily both with my unit tests &
DAL, as well as on another machine with the same relative directory? My
current app.config is below: Please let me know if there is a more
appropriate forum to post this to. Thanks!
-------
<configuration>
<configSections>
...
|
Import txt file to sqlce table
Mon, 21 Jul 2008 16:06:14 +0200
Hii
said that are brand new environment VST 2005
I'm trying to implement an application for pocket
when would the need to import data into a table
(Articles)
with three fields ID Code, Description
an archive. sdf on the pocket, from a txt file, the data are on txt
delimited;
I do not know the best idea ho ...
|
Getting and Installing
Thu, 17 Jul 2008 09:01:00 -0700
I am a Software Developer, and I love the idea of using SQL Server CE instead
of Microsoft Access; however, I seem to run into the problem of not being
able to find the place to download it from! Is it contained in a single file?
Is it SQL Server CE or 2005 Mobile? I found the Modile Edition SDK, but does
th ...
|
|
|
varchar(max) and varbinary(max) length problem in SQL CE 3.5 sp1
Thu, 17 Jul 2008 07:06:01 -0700
We are currently have a problem with a new application, where we are using
the Entity Framework (Visual Studio 2008 SP1 beta), which only uses the
latest version of SQLCE 3.5 sp1 to read / update SQL Compact edition. This
currently is for a desktop application.
It seems that it is limited to only 8K of bin ...
|
transaction & tabledirect
Thu, 17 Jul 2008 02:02:02 -0700
Hello,
I insert rows in a table using a tabledirect command, and a SqlCeResultSet.
Could someone help me with the following questions ?
- When are the result flushed to the disk ?
- Is it possible to use transactions ?
- is-it a good practise to maintain a SqlCeResultSet through the application
live and ...
|
Merge Replication MS SQL CE 3.5 <-> SQL SERVER 2005
Wed, 16 Jul 2008 05:10:31 -0700
Hi there.
I have been trying to get merge replication to work between a Windows CE
device with SQL Server Compact Ed 3.5 and SQL Server 2005. I have made good
progress but got stuck with an error that Google canâ??t help me with. Firstly,
I will discuss my progress for those who might hope to get as far as ...
|
