GIS functions on SQL Compact 2008
Fri, 26 Sep 2008 09:17:25 +0200
Hi All,
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 ?
Is there the possibility to develop a portable GIS software with SQL Server
Compact ...
|
Problem to create tables
Thu, 25 Sep 2008 11:55:24 +0200
Hi all,
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)
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server Management Studio (version 9.00.3042.00)
I tried ...
|
?? Dropping a Constraint, Checking for Table Existence ??
Sat, 20 Sep 2008 12:58:50 -0500
Hi all,
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
dropping it? The "IF" statement from regular SS is not supported ...
|
Best Practice for many to many tables
Fri, 19 Sep 2008 04:13:01 -0700
All,
We have a senario where we are joining 3 tables for a query that could have
a many to many relationships, between 2 of the tables. I want to know what
is the best way to go about it? also what would be the best way to go about
it if say a 3, 4 and 5th table were many to many relationships.
We want ...
|
How to SQLCE2.0 files for smartphone
Fri, 19 Sep 2008 03:23:02 -0700
Hi,
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
Thanks
...
|
ALTER TABLE and COLUMN IDENTITY
Fri, 19 Sep 2008 10:24:29 +0100
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)"},
{L"INSERT INTO PieceDefinition VALUES (0, 0, 0, 0)"}, // outing specific
data.
{L"INSERT INTO PieceD ...
|
Installing SSCE 3.5 for VS2008 problems.......Totally Lost
Thu, 18 Sep 2008 16:26:21 -0700
Hello All,
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!!!!!!
If I create a project in VS2008 (win for ...
|
|
|
SSCE 3.5 issues Help!!!!
Thu, 18 Sep 2008 06:37:03 -0700
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
SQLCE 3.5 sp1 anyways and tried to connec ...
|
Opinions? Copying SDF while conn is open:
Wed, 17 Sep 2008 09:25:53 -0700
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
feeling a little uneasy. I'd hate to find out later that it sometimes
raises ...
|
SQL Dumper library failed initialization...
Tue, 16 Sep 2008 22:36:01 -0700
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
correct this problem."
I think I did this accidentally when I was in a ...
|
