Can't drop table because "The system timed out waiting for a locK".
Wed, 23 Apr 2008 14:42:41 -0400
Hello,
I'm using VS2005 (vb.net) and sql ce compact edition (3.0).
This app. had been working in the past, but a new issue has popped up.
Normally what is supposed to happen is, from the device (using RDA), I push
the data to the server , drop the table, then repull the data from the
server. This had ...
|
custom insert for databound datagridview
Wed, 23 Apr 2008 11:41:06 -0700
I don't know if this is the right forum to post this in, but I will start
here....
I am writing a desktop database application. I created a simple SQL CE
database. I then created a new form and dragged the DataGridView control from
the toolbox to the form.
I then created a new data source and pointed it ...
|
VS2008 and Compact Server 3.5
Wed, 23 Apr 2008 08:22:42 +1200
Hi,
Oops, accidentally posted this to the C# group so apologies for cross
posting.
VS2008 IDE Desktop app.
Anybody out there deploying this db?
I am finding a strange problem with column names.
I am using an SQLCeCommand to create a datareader.
I have a where clause that is refusing some of the column ...
|
Performance problem in sql ce
Mon, 21 Apr 2008 02:26:01 -0700
Hi,
I am very disappointed with the sql queries performance in sql ce. In my
some queries i have inner joins on 9 tables some tables have more then 150000
records. Db size is around 15 MB. If i run that query with particular where
clause (ex RoomNo. = 100) then it gives result in 1 minute otherwise i wait
...
|
Secure your MSSQL server
Mon, 21 Apr 2008 00:06:54 -0700 (PDT)
Hi Gurus,
MSSQL servers are among the most commonly used servers. But we also
know that MSSQL server security is a critical concern for most of the
database administrators. This task will become handy with the help of
Secure Auditor which is a unified digital risk management solution
capable of auditing, enfo ...
|
Distributing SQL CE 3.5
Mon, 21 Apr 2008 16:51:34 +1000
Is there any MSM (Merge Module) files available to distribute the SQL CE
3.5. I have the MSI downloaded from MS downloads page, but I want to
integrate the installation with my applications setup.
As I need only the OLEDB features to populate the database on desktop, can I
distribute only certain files (E.g ...
|
SQL Server CE on PPC, mdb on Desktop pc; how is it possible to exchange data ?
Thu, 17 Apr 2008 18:44:27 +0200
Hello.
I'm facing a problem about the interaction between desktop Pcs and palmtops
that apparently is not documented.
I have got a C# device application running on a PPC with Windows Mobile 5
and SQL Server 2005 CE. I would like to establish a connection with an
access database located on a destop PC. Is the ...
|
|
|
Insert during Select
Thu, 17 Apr 2008 13:31:30 +0200
Hello.
Can i insert a record in a table B during reading records in a table A (Sql
Compact Edition 3.1)?
Something like this:
SqlCeConnection c=new SqlCeConnection("Data Source=\test.sdf");
SqleConnection d=new SqlCeConnection("Data Source=\test.sdf");
SqlCeCommand cmd=new SqlCeCommand(c ...
|
SQL Compact 3.1 corrupt database with password
Thu, 17 Apr 2008 11:56:31 +0200
Hello,
I have a password secured 3.1 database that has been corrupted (don't know
why). However, when I try to do a verify or repair I cannot access the
database with the original password, I get the message that the password is
incorrect.
Is there a way to repair this database ?
Thanx in advance,
...
|
Could not load sqlcecompact30.dll
Wed, 16 Apr 2008 21:38:00 -0700
Hi,
When I try to exit my program in PDA.
it give me the error below.
RealTimmeMobileSys.exe
SqlCeException
Could not load sqlcecompact30.dll. Operation has been aborted.
at System.Data.SqlServerCe.SqlCeEngine.ProcessResults()
at System.Data.SqlServerCe.SqlCeEngine.Repair()
at System.Data.SqlServerCe.S ...
|
