What causes error -2147217887 (80040e21) in the following recordset open
call?  The connection opens without error.
Sub test()
   Dim CNN As New ADODB.Connection

I've tried to sign up for a redistribution license at this page:
http://www.microsoft.com/sql/editions/compact/redistribute.mspx
But keep getting an error when I try to submit my details.
Has anyone here had any luck?

I know that the new spatial types of SQL Server 2008 (geometry, geography)
are mapped on image type: could tell me if the GIS functions
(STGeomFromText, STGeomFromWKB and so on) are supported on the compact
platform ?

i'm totally newbie about SQL Compact Edition, I've downloaded it from
Microsoft site the latest version and installed it on my development pc
with:
Visual Studio 2008 (no Service Pack 1)

I'm working on smartphone windows Mobile 5. I want to use SQLCE2.0 in my
project. but I didn't find any files for SQLCE2.0 for smartphone.
can any please help me. From where do i get SQLCE2.0 for smartphone?
Please help me its urgent

I am having major issues trying to get to the point where I have SQL
Serverce 3.5 installed for both Desktop use as well as for Smart Devices.
I have spent the better part of my day installing and unistalling these msi
files that Microsoft says works!!!!!!

I'm using SQL Server CE 3.5. I am using SQL Server Management Studio 2008 to
put together a SQL script for the creation of tables and I have two
questions.
First, is it in anyway possible to check for the existence of a table before

Here I go again. I am moving to VS2008 on a Vista machine. I need both the
desktop capability of sqlce 3.5 in addition to
the mobile functionality. I understand that SQLCE 3.5 is installed via
VS2008 sp1 correct? It does not show up in "Add Remove Program" I installed

When I re-start my system I have been getting an error message....
The exact message is....
"SQL Dumper library failed initialization.  Your installation is either
corrupt or has been tampered with.  Please uninstall then re-run setup to

I want to copy the whole .sdf to another file as a db backup.
It would be convenient to do this from the application while leaving the db
connection open.
I've tested just a bit, and it seems to work fine.  But it does leave me

I'm naively trying to reserve a couple of fields in my database when I
create it, like this.
{L"CREATE TABLE PieceDefinition (ID INT, OwnerID INT NOT NULL, StartTime
INT NOT NULL, EndTime INT NOT NULL)"},

I am trying to copy the data from one database table to another database.
The code executes without error but the data is not copied across.
My code I am using:
       Dim oDS As New System.Data.DataSet

I'm developing with VS2005, but sometimes just need a quick and dirty way to
display and edit fields in the database.
Is there any simple way to do this?  Access 2007 doesn't know how to attach
an OLEDB table, and SQL Server Management Studio 2008 can display the

Where do you guys think the .sdf should go if you're deploying to the
desktop?  I'll be installing on XP and Vista (maybe even Win 2000).
I have been installing the .sdf in the application directory (actually
DataDirectory with no adjustments, same effect).  This has worked OK so

I have a C# application originally created in VS2005 that was used to create
a test database.  However, now that I've included the C# code into a VS2008
project and re-setup the SQL references, I receive the following error:
An unhandled exception of type 'System ...