Sql ce 3.5 OleDB Driver
Mon, 10 Dec 2007 10:03:09 -0000
My main application is written in a language called Gupta team developer.
I need to be able to communicate with a sql ce 3.5 database.
However there is some strage things with the OleDB driver.
It is no problem establishing the connection to the database, but when ever
I try to bind variables in Sql Statemen ...
|
SqlCeResultset and DataGrid in CF
Fri, 7 Dec 2007 02:19:02 -0800 (PST)
Hi,
Help please to troubleshoot with SqlCeResultset and DataGrid in CF v2.
I do so:
public System.Data.SqlServerCe.SqlCeResultSet CustsResulSet = null;
public SqlCeResultSet GetExecuteResultSet(string _comText, bool
_updatable)
{
SqlCeCommand cmd = new SqlCeCommand(_comText, sqlCeConnection);
resul ...
|
ISQLW35.exe compact feature...
Thu, 6 Dec 2007 08:53:48 -0800
Friends,
We migrated our application from SSCE 2.0 to the official SSCE 3.5, and look
forward to the extra robustness. We were hoping to be able to use
ISQLW35.exe to compact, but our DB is password protected. I am never
prompted for a password, and I just get an "Unspecified Error" once I
confirm that ...
|
SQL Server 2005 to SQL CE 2.0
Wed, 5 Dec 2007 06:50:26 -0800 (PST)
I have merge replication configured between SQL Server 2000 and SQL CE
2.0 which has been working fine for the past few years. I need to
migrate my Server 2000 database to SQL Server 2005 and set up merge
replication there. Can I simply point my device to the new database
on SQL Server 2005 and have merge repl ...
|
Connect to SQL Server 2005 at Vista from device with WM5.0
Tue, 4 Dec 2007 03:45:01 -0800
Hi
We have developed an application with vb2005 running under WM5.0 how
connects direct to SQL Server 2005 using WLAN (Using system.data.sqlclient
ver 3.0.3600 from ..\Smartdevices\sdk\SQL
Server\Client\v2.0\system.data.sqlclient.dll).
Everything works perfect when we connect to an SQL Server 2000 (ver 8.) ...
|
ODBC in SQL Server CE
Mon, 3 Dec 2007 11:25:00 -0800
Hi,
Does anyone know if and how I can access a SQL Server CE 3.0 database using
ODBC? (Is there an ODBC driver available for SQL Server CE?)
If not, what are the methods for accessing a SQL Server CE 3.0 database?
Thanks.
...
|
A fast way to delete all records
Sun, 2 Dec 2007 14:20:31 +0100
Hi all,
in a Sql Server Compact Edition 3.5 database I just need to delete all the
records in a table, is there any way faster than execute a DELETE FROM
statement, or more practical than deleting the table and recreate it?
UnfortunatelyTRUNCATE TABLE is not supported...is there another way?
...
|
|
|
Upgrade SQLServer CE database to 3.5
Fri, 30 Nov 2007 09:18:55 -0800 (PST)
When trying to use the latest SSCE 3.5 for WinCE 6.0, my databases
created with SS 2005 will not open -- says they were "created by an
earlier version of SQL Server Compact."
So I tried to use the Upgrade.exe however that apparently wants the
source db to be SSCE 2.0, and I'm guessing mine are either 3.0 or ...
|
SSCE from multiple PCs?
Wed, 28 Nov 2007 18:38:48 -0800 (PST)
I'm looking for a light-weight database engine I can use for multiple
users accessing the same database over a LAN (and I know that client/
server is recommended, but not an option for me). I want something
from Microsoft. I saw SSCE which looks great, but unlike JET Red it
doesn't appear to handle multiple wo ...
|
system table on SDF to query to see if I have a pending change
Tue, 27 Nov 2007 11:10:06 -0800 (PST)
I am looking for something in the SDF to tell me that I have data that
has changed.
I found the __sysDeletedRows and that is all fine for deleted rows,
but I want to know about inserted/updated rows as well. The tables I
see do not show me that information.
Any Ideas?
Below is the list of system tables ...
|
