|
SQL server CE 2.0 COMPACT database
HELLO
I have problems with compacting SQL server ce database.
When i compact database i get error -2147467259 and compact stops.
I write my program in eVB, but also code in C# not work.
string src = "mm.sdf";
string dest = "mm.sdf.tmp";
SqlCeEngine engine = new SqlCeEngine("Data Source = " + ...
Wed, 1 Sep 2004 11:14:14 +0200
|
need help
can neone help me in accessing SQL server CE using embedded visual c++
3.0...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! ...
Wed, 01 Sep 2004 01:52:18 -0700
|
Update and Delete After Replication
I'm using VC++ 3.0 for Embedded Systems, and using modified ATL OLE templates
to do my database access. I can create new recods through my application on
the handheld and I can modify or delete anything that was orginally created
on the handheld, but I can't do either on records that originate from my SQL
S ...
Tue, 31 Aug 2004 11:35:05 -0700
|
sql File Sharing Violation
I have a compact app that accesses sql ce just fine. Only 1
connection object used, no 25035 sharing errors. i dispose any
commands after they've executed, close and dispose any datareaders
after they're done, and then when i close my app (the closing event) i
close the lone connection (check the state, make ...
31 Aug 2004 11:13:28 -0700
|
SQL Server CE Administration (NTFS Permissions)
When I attempt to specify the NTFS UNC share for the snapshot folder
to the Administrator user through IIS it tells me that the network
location cannot be reached.
The location is there. I explicitly assigned the user permissions on
the share and the folder.
I also assigned permissions to the GROUP Administr ...
31 Aug 2004 07:33:47 -0700
|
total newbie: problem with replication
Hi!
IDE: VS 2003 .net + sqlserver2k + sp3
Microsoft SQL Server CE 2.0
OS: XP pro
Here is some of my code in my test app for pocketpc:
SqlCeReplication rep = new SqlCeReplication(
@http://localhost/Nwind/sscesa20.dll,
"","",
"PC3",
"Northwind",
"Northwind",
"Testing",
@" Data Source=\My Documents\t ...
Tue, 31 Aug 2004 16:00:09 +0200
|
Error during Replication
I am getting this error while trying to merge replicate:
Error Code: 80072ee2
Message: A request to send data to the computer running IIS has failed. For
more information, see HRESULT.
Minor Err.: 28037
Source: Microsoft SQL Server 2000 Windows CE Edition
Now I know that HRESULT is another error message ...
Tue, 31 Aug 2004 06:37:01 -0700
|
Merge replication with Oracle
Hello
Is it possible to use SQL CE and merge replication with an Oracle database.
Or does anyone know a smart workaround.
Regards Henrik Juel
...
Tue, 31 Aug 2004 08:54:51 +0200
|
Replication error
I have set up replication through the .net Compact Framework. It works through the builtin Emulator with the Pocket PC 2002 and 2003. I have deployed the application to a Pocket PC 2003 device but I get the following error message:
ERROR MESSAGE: 80004005
Native Error Message: 28003
The IIS computer is out ...
Mon, 30 Aug 2004 07:46:05 -0700
|
Export DB to SQL Server mobile edition (2)
Hello,
which steps are necessary to generate a database file for the SQL Server
mobile edition (*.sdf) from a database (e.g. Access, SQL) on a host PC with
SQL Server 2005 Management Studio.
I succeeded generating a new database from the Management Studio, however
I'd like to port a existing database to ...
Mon, 30 Aug 2004 07:37:12 -0700
|
SQL Server CE v2.0 performance optimization
http://www.sqlservermobile.com/SQLMobileWebCasts/MBL348.wmv
Please check this web site out regarding performance optimization for SQL
Server CE v2.0 for managed code. The second part of the web cast focuses on
Nabisco case study, how they deployed to 1500 devices, what they did for
disaster recovery and h ...
Fri, 27 Aug 2004 17:21:47 -0700
|
SQLCE Image data conversion to SQL Server 2000 Image
I have finally successfully used RDA - Pull to execute a stored proc
to transfer data from a table containing an image (which is just a
stream of an small html file) to the SQL Server 2000 data store. Now
I'm writing a GUI that will have a view to the SQL Server 2000 data.
On the Winforms program after I perf ...
27 Aug 2004 13:42:15 -0700
|
SQLCE Limitation?
I am writting an application on a pocket PC device and am having problems
with my SQL queries. The problem I am faced with is that queries that I write
for SQL2000 work fine and then when I run them on SQLCE I get parsing Errors.
I have been looking for information on the limitation of SQLCE and haven't
fou ...
Fri, 27 Aug 2004 07:53:03 -0700
|
SQL Server Mobile Edition Beta
Hello,
I just installed "SQL Server 2005 Beta 2" and "SQL Server 2005 Mobile
Edition Server Tools" to evaluate the feature to generate a database file for
the SQL Server mobile edition on a host PC, which isn't possible with SQL
Server CE 2.0.
This feature is described in document "Introducing SQL Serve ...
Fri, 27 Aug 2004 06:41:02 -0700
|
Generate a new guid
Hi all,
is there a method or property of a class that will
return a GUID in VB.NET that I can use as
the PK of my DB. I do not want SQL to generate
it as I can not then use
SELECT @@IDENTITY to retrieve it.
I want to try and mimic the functionality of
newID()
that SQL server has.
Thanks,
Ja ...
Fri, 27 Aug 2004 12:40:37 GMT
|