How Do I Install SQL Server Compact Edition From A Storage Card On A Device

Feb 26, 2007

Hi all experts,

in case of a cold boot on a device, I insert the the flash SD disk in a device and install the NETCF 2.0

by clicking on the NETCFv2.wm.armv4i.cab which iI previously copied, that's fine it works OK,

but is there a cab file for Sql server CE that i can install from the flash disk as well,

I'm trying the Sqlce30setupen.msi, SQLServerCE31-EN.msi, an I get a device message "There is no application associated....."



TIA

Jack

View 3 Replies


ADVERTISEMENT

Can I Install SQL Mobile On Storage Card ?

Aug 24, 2007

Hi,

SQL mobile apps like - .Net Frame work, SQLCE mobile etc - can they be install on the Storage Card? I am running out of space on my Verizon 6700 and don't have enought memory to install on the device. I cleaned up as much as I could still not enough space on the device.

Can this be done?

Thanks,

P

View 7 Replies View Related

SQLce / WM5 Phone Edition (T-Mobile MDA) / Storage Card

Jul 29, 2007

I have built an application for storing my flight times on my phone after each leg of a trip... I am using C# and Sql CE as the storage system for later export to a larger desktop version (in the works). My question is related to storing the sdf file on the storage card. Can it be done and what would the connection string look like since I have tried and got a error stating it can't find the sdf file in question. I have it setup right where if I were to do a fresh install it would ask for the install directory main memory or storage card. If I select storage card it installs just fine but when I run the app it does fail with the aforementioned error..

Storage Card is 2 gigs..

Thanks

Morgan Vermef

View 3 Replies View Related

Windows CE 5 Device With SQL Server 2005 Compact Edition Sync With SQL Server 2005 Express Edition

Oct 25, 2007

I have:

A server computer running SQL Server 2005 Enterprise Edition.

A industrial computer running SQL Server 2005 Express Edition.

And now also a Psion WorkAboutPro with CE 5 that should run SQL Server Compact Edition.



The industrial computer syncs its data with the server, basically saying "this has happened".

Now I want the Psion to sync with the industrial computer, but this sync must two-way.



I have tried to find a guide or something that can tell me "do this to sync" but the information i have found is sketchy at best.



If someone could point me in the right direction of a guide or something else it would be much appreciated.

Regards,
Björn

View 9 Replies View Related

SQL Compact Edition Slow On Device

Apr 15, 2007

The Compact Edition is so slow. A simple query takes 2 minutes to Prepare, or Excecute. The same query is very quick in ISQL.



Dell Axim. WM5. Database was created on the Desktop with Compact Edition libraries. Has needed indexes and is a select based off that index, and joins one other table which is also indexed on the join column.



Is SQL Mobile quicker ? I just wanted to be able to create a database without having to use replication to populate it, and the Compact Edition allowed that.



Thanks in advance.MC

View 4 Replies View Related

Sql Server Mobile 2005 And Emulated Storage Card

Dec 19, 2005

Using shared folder in windows mobile 5 emulator,  it is not possible to create a database (sqlserver mobile 2005)   in the emulated storage card.

The error "sql mobile made an unsupported request to the host operating system. Minor Err 25133 is raised.  Reading or writing file from/to  the emulated storage card occurs without error.

Is this a bug of  SqlCeEngine?

thank you

vincenzo

 

 

View 6 Replies View Related

Sqlceoledb35.dll - Error 25123 - A SQL Server Compact Edition DLL Could Not Be Loaded. Reinstall SQL Server Compact Edition.

May 5, 2008

Hello,

we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.

Why is this error happening and how can we resolve this?

BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.

Thanks,
Markus

View 1 Replies View Related

A Sql Server Compact Edition DLL Could Ot Be Loaded Reinstall SQL Server Compact Edition [ DLL Name = Sqlceca30.dll]

Mar 11, 2008



Hi there,

everything is ok for first run. but i leave the program relogin
than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine.
can anybody help me?


VS2005 ver 8.0.50727
SSCE31VSTools-ENU.exe loaded
SSCE31SDK-ENU.msi loaded

machine 1
SQL 2005 loaded

machine 2
http://192.168.20.22/ssce/sqlcesa30.dll
"Microsoft SQL Server Compact Edition Server Agent" looks fine

pocket pc side
C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4

.net cf 2.0 sp2
sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB installed too.

my code
---------------------------------------------

Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"

Dim rda As SqlCeRemoteDataAccess

Try

rda = New SqlCeRemoteDataAccess "THIS LINE GIVES ME THAT ERROR
Catch ex As Exception

MsgBox(ex.ToString)

Application.Exit()

End Try

Try

rda.InternetLogin = [String].Empty

rda.InternetPassword = [String].Empty

rda.InternetUrl = "http://" + IP_no + "/ssce/sqlcesa30.dll"

rda.LocalConnectionString = ConnectString

Catch ex As Exception

MsgBox("Bağlantı hatası..")

Application.Exit()

End Try
------------------------------------------------------------------------------
i added the following code to very beginning of my code too.
that code lock my device


Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr


Dim pt As IntPtr

pt = LoadLibrary("\windowssqlceca30.dll")

pt = LoadLibrary("\windowssqlceoledb30.dll")

pt = LoadLibrary(\windowssqlcecompact30.dll)


-----------------------------------------------------------------------------

View 4 Replies View Related

Can't Install IBM Tivoli Storage Manager Server On Windows 2003 X64 Storage Server, How Can I Fix The Pkg?

Jan 14, 2008

I am a Windows developer for the IBM Tivoli Storage Manager Server (TSMS) product.
Our product installation is built with InstallShield and uses the Windows Installer.

On a new installation of Windows 2003 x64 Storage Server R2, at a customer's site, the TSMS product fails to install.
The install of the OS has version 3.01.400.3959 of the Windows Installer and I see no newer version that installs.

Part of our product is 32 bit (console) and another part is x64 (server).
When installing I can see that the install's default is being redirected/reset to C:Program Files (x86)TivoliTSM after it is explicitly set by a custom action to ..Program Files.. . I further observe that our custom actions to write 64 bit registry entries are being refused.

REGSAM samMask = KEY_ALL_ACCESS;
if ( regIsWow64Process () ) samMask = samMask | KEY_WOW64_64KEY;
lStatus = RegCreateKeyEx( hLocalConnectKeyRoot,
szSubkey,
0L,
NULL,
REG_OPTION_NON_VOLATILE,
samMask,
NULL,
hKey,
&dw ) ;
The above fails to create the key.

We have tried four versions of our TSMS spanning many changes but the install acts the same.
This does not happen on any other Windows OS we test on but we do not test on Windows 2003 Storage Server R2 being that it is an OEM product. We did test on Windows server 2003 R2 x64 and do not see this problem.

Do you have any suggestions on how to tackle this problem?
I have full installation traces but can only see that the registry work is being refused. I can't see why.

View 1 Replies View Related

Merge/Replication To And From A Storage Card

Jul 27, 2007

Hey,

My team is currently building a system for the Windows CE 5.0 platform that uses a SQL CE database to synchronize with a SQL Server 2005 database. During this synchronization process, the application needs to pull down a good bit of data and it reaches its cap for memory. A possible solution for this is to use an SD card for storing the database. However, when the Synchronization process is run, the following SQL Exception Occurs:

HResult = -2147467259
Message = "SQL Mobile encountered problems when creating the database."
NativeError = 28558
Source = "Microsoft SQL Server 2005 Mobile Edition"
StackTrace = at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeReplication.AddSubscription()
Our Trace
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
Main

The connection string we're using for the Mobile Database is "data source=Storage CardDatabase.sdf"

Has anyone ever had any problems when trying to perform Merge/Replication on expandable Flash Memory and if so, how did you solve them?

Thanks,
Matt

View 4 Replies View Related

Creating And Using Database On Storage Card

Nov 7, 2007

Hi all.

I develop a app on PPC 4.20 using SQLServer 3.1. I developed a o/r mapper whitch auto-creates the Database and Tables using attribute-decorated objects. That all works fine - as long as my Database is in \MyDocuments .
Trying to store the Database in \Storage Card\test.sdf, whitch is absolut neccessary because it will become to big for storing onto device, I get error 25113, "A not supportes operation to host was called" (Translated from German)

When I trie to copy a Database to the SD-Card, inserts are not commited.

Is it not supported to store Databasefiles on a Flashcard?

My development-environment is .net 2.0 sp2, device-emulator v2, Windows XP, vs2005. In the emulator, i have linked a windows-based directory as storagecard.

What am I doing wrong??



class SQLManager
{
private static SQLManager instance = null;

private SqlCeEngine m_cEngine = null;
private SqlCeConnection m_cConn = null;

private SQLManager()
{

m_cEngine = new SqlCeEngine(
"Data Source = \Storage Card\test.sdf");

bool bCreated = false;
if (!File.Exists("\Storage Card\test.sdf"))
{
bCreated = true;
m_cEngine.CreateDatabase();
}

m_cConn = new SqlCeConnection(
"Data Source = \Storage Card\test.sdf");
m_cConn.Open();

if (bCreated)
DoInitialDatabaseSetup();

}
....

}

View 6 Replies View Related

ASP.NET And SQL Server Compact Edition

Sep 25, 2007

I am writing an application that is designed for the desktop, or small group (3 or less) desktops.  The application is being deployed using the Cassini web server as a complete "embedded" solution.  I wanted to use SQL Server Compact because of its small footprint and because of the synchronization capabilities with SQLServer.  Also, it is very easy to deploy vs. SQL Server Express.  The idea behind this APP is that someone might use it locally and then decide to subscribe to the service and then connect the same application to  a web services application. 
 That being said, and with knowledge of Microsoft's stance on SQL Compact under ASP.NET, I have most everything working and it works great except for one thing.  When I add a SQLDataSource to the page and set the connection string to my file and the DataProvider to System.Data.SqlServerCe and then bind a data grid to the SQLDataSource, it runs fine on my development machine, but when I deploy to my clean test machine, I get an error when the page loads saying:
Unable to find the requested .Net Framework Data Provider.  It may not be installed.
I can create a dataset in code (in fact,in several other places I do) and it works fine.  It is just the SQLDataSource(s) that are throwing this error.  I have a copy of System.Data.SqlServerCe.dll in the bin folder and I have all of the compact DLL's in the bin folder as well.  I can't figure out what I need to do.  I also have a reference to the System.Data.SqlServerCe in the web.config file.
 Can anyone help?
 
 

View 3 Replies View Related

New SQL Server Compact Edition

Jan 9, 2007

Does the new SQL server Compact edition RC1 (release in Dec 2006) replace the Microsoft SQL Server 2005 Mobile Edition Device SDK?

OR is this an additional database for specific requirements.

Currently developing against MS SQL Server 2005 Mobile Edition Device SDK;; if I switch to the Compact edition; is there a migration wiarzrd or Upgrade wizard available?

-jawahar

View 1 Replies View Related

SQL SERVER 2005 EXPRESS EDITION AND WINDOWS STORAGE SERVER 2003

Nov 28, 2007

Hi,
I have a question to do..
can I install sql server 2005 express edition on a windows storage server 2003 R2????
Thank-you!!
MTV

View 3 Replies View Related

SQL Server Compact Edition RC1 Released

Nov 7, 2006

Dear Community,

The SQL Server Compact Edition RC1 has been released and is now available at download center http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en

Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn€™t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx?FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en

We have blogged about it at http://blogs.msdn.com/sqlservereverywhere/ .

Please check out the RC1 bits.

Thanks
Sachin, Program Manager, SQL Server CE Team

View 10 Replies View Related

Java And SQL Server Compact Edition

Oct 23, 2007

Hi, Is there a special jdbc driver for SQL Server Compact Edition (2005) available? I'm getting error messages when trying to run java application on Pocket PC (Mobile 5.0):

java.lang.UnsatisfiedLinkError: java/sql/DriverManager.getCallerClassLoader()Ljava/lang/ClassLoader;
at java.sql.DriverManager.getConnection(Unknown Source)...

Mixxo

View 1 Replies View Related

Access To SQL Server 3.5 Compact Edition

Apr 10, 2008

Is there a way to import the table definitions and data from an Access database into the 3.5 compact edition? I have no clue where to start. I have a .Net application that uses an Access database to store data. I want to create a windows mobile application for collecting the data and syncing with the PC application. Is the 3.5 compact edition the way to go? How do I get started? I don't even know how to open the interface for the database.


I'm certainly no newbie to programming, but the SQL Server and Windows Mobile stuff is like starting all over in some ways.

View 3 Replies View Related

SQL Server Compact Edition 3.5 C++ Sample

Jan 14, 2008

Hi,

I am looking for C++ example using SQL Server Compact Edition 3.5.
I managed to compile and run the "northwindoledb" c++ example, but still, I am looking for source code to 3.5 (And not 3.1).

View 17 Replies View Related

Accessing SQL Server Compact Edition From VBA

Dec 12, 2006

Is it possible to connect to SQL Server Compact Edition with Visual Basic for Application?

I want to connect to *.sdf file from MS Access.

View 3 Replies View Related

Looking For A Very Simple SQL Server Compact Edition App Example

Jan 20, 2007

Hi to all,

I am new to VS, hence new to CF too,

Using VS2005 SP1, CF2.0, PocketPC Mobile 5.0 emulator.

Im looking for the most  simple example I can get to create a db and a table just to understand the very basics of SQL Server Compact Edition.

I did some gui examples posted in MSDN, it worked fine, no problem.

But I don't want to  use the toolbox dragging DataGrid, DataSourceBinding or Northwind.sdf, or any of that.

All I need is to be able to create a simple db, a table with two columns, and a connection to do very simple query,

I searched and searched, cannot find my simple guide.

 

Can anybody help me resolving this?

here is my test.

opened a new project, named MydbTest2
added a reference to System.Data.SqlServerCe
added a button to the form1
added a using directive System.Data.SqlServerCe
and this is the rest.

I get errors about
Error 1 The name 'myConn' does not exist in the current context F:My.VS.ProjectsMydbTest2MydbTest2Form1.cs 33 13 MydbTest2

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
using System.IO;


namespace MydbTest2
{
    public partial class Form1 : Form
    {

       
        public Form1()
        {
            InitializeComponent();
        }

        private void menuItem1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connStr = "Data Source = myDbTest.sdf";
            SqlCeEngine myEngine = new SqlCeEngine(connStr);
            myEngine.CreateDatabase();
            SqlCeConnection myConn = new SqlCeConnection(connStr);
            myConn.Open();

            SqlCeCommand cmd = myConn.CreateCommand();
            cmd.CommandText = "CREATE TABLE myTable (firstCol int, secondCol nvarchar(10))";
            cmd.ExecuteNonQuery();

        }
    }
}

View 1 Replies View Related

SQL Server Compact Edition && VB.NET 2003

Jul 24, 2007

I'm unable to create a connection with code from VB.Net 2003 using SQL Server Compact Edition. Can anybody help?

View 1 Replies View Related

SQL 2008 Developer Edition Management Studio Does Not Work For Compact Edition 3.5 Databases

Sep 27, 2007



I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA

Problem Creating the Compact Database:


Open 2008 Management Studio

From menu choose File | Connect Object Explorer...

Choose SQL Server Compact Edition as the Server type.

Choose <New Database...> as the Database file.

Browse to folder where file will be created (C:MyDatabase#1.sdf was used in my example)

Leave all other field as default selections OR make changes, either way it does not work.

Click OK.

At this point the OK button just becomes disabled and nothing happens.
Problem Opening An Existing Compact Database:

Open 2008 Management Studio

From menu choose File | Connect Object Explorer...

Choose SQL Server Compact Edition as the Server type.

Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008.

Enter password, if any.

Click OK.

The following exception is displayed:
TITLE: Connect to Server
------------------------------
Cannot connect to C:Documents and SettingsdarrinbMy DocumentsVisual Studio 2008ProjectsTestSQLCompactEdition35TestSQLCompactEdition35AFS.sdf.
------------------------------

ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib)
------------------------------
BUTTONS: OK
------------------------------

View 1 Replies View Related

Help - SQL Server 2005-&>Compact Edition Replication

Jan 30, 2007

Hi All ...I
have been following the MS on-line tutorials to get replication setup
between SQL Server 2005 and SQL Server Compact Edition. I get to the
point where I run the Configure Web Synchronization and it is running
through the process where it is doing the automated configuration of
the shared directory - assigning users etc.I have attempted
this step with a user account that I expressly created for snapshots
and with the Administrator account and get the following error message:* The operation completed successfully. (Exception from HRESULT: 0x80070000)At
first, I thought this was a rights issue due to the fact that I was
using an account that I manually created. However, by using the
Administrator account (test only until I can figure this out) that
should have removed any rights issues associated with accessing the
shared directory where the snapshot will reside.Any help in getting this figured out will be greatly appreciated.David L. Collison Any day above ground is a good day!

View 9 Replies View Related

Need Help Installing SQL Server 2005 Compact Edition.

Dec 15, 2006

Hi,

  Having read a lot about SQL Server 2005 CE, I decided, after seing that it was finally available, to start its installation.

1-  I downloaded and installed SQL Server 2005 Compact Edition from following link:

http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en

2- Also I downloaded and installed SQL Server 2005 Compact Edition books online from following link:

http://www.microsoft.com/downloads/details.aspx?FamilyId=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en

==>  Is there anything else missing if I intend to use it for development with Visual Studio 2005 (VC++)?

==> What is "Microsoft SQL Server 2005 Compact Edition Developer SDK"  compared to the one "SQL Server 2005 Compact Edition" I installed?  Should I install it? 

ref: (http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en)

3- There is also a link, which btw doesn't work at all, that should allow me to download following item:

"Microsoft SQL Server 2005 Compact Edition Tools of VS 2005 sp1"

==>  Not being able to have any infos about it, what is the use of it?  Should I install it in my environment? If so, any working link where I can download it from?

4-  I finally noted, while browsing through SQL Server 2005 CE books online, the following note:

The following programming models are supported by SQL Server Compact Edition:

ADO .NET, accessible by using C# or Microsoft Visual Basic

OLE DB, accessible by using Visual C++ option from within Visual Studio 2005


==> How come that CE is not accessible using ADO.NET model when using VC++?

 

Thanks in advance,

Stéphane

View 9 Replies View Related

Compact Edition V3.5 And SQL Server Management Studio

Oct 1, 2007



Is it possible to use SQL Server Compact Edition v3.5 with SQL Server Management Studio?
When I attempt to connect to a 3.5 database I get the following error:

"You are trying to access an older version of a SQL Server Compact Edition Database..."


I am using v3.5 beta 2.

If not, is there anything out there that provides a Query Analyzer like interface for viewing data that works with v3.5?

Thanks.

View 3 Replies View Related

ODBC Driver For SQL Server Compact Edition

Jan 31, 2008

I know that there is no ODBC driver available for SQL Server Compact Edition version 3.5. Do you plan to add an ODBC driver in future release? If yes, is it high in your priority list?

The scenario why I am looking for an ODBC driver is to connect an MS Access application to a SDF file instead of MDB file. This will enable me to easily sync the SDF file with SQL server repository using the new Data Sync Services.

Mario Cardinal
MVP Solutions Architect

View 20 Replies View Related

Installing Sql Server 2005 Compact Edition

Mar 28, 2007

I have a PDA application that manage a database.

My application uses Sql server 2005 Mobile edition and I want to change to

Sql server 2005 Compact edition.

I have an application that automatically upgrade new version of my software at users (customers sites) It is shipped on a memrory card (SD Card).

I want in my upgrade tool to install Sql server 2005 Compact edition so I do it by running the two cab files :

sqlce30.repl.wce5.armv4i.CAB and sqlce30.wce5.armv4i.CAB

It works ok but I want also to uninstall Sql server 2005 Mobile edition and I do not find out how to do it automatically, First I do not know how to find out if Sql server 2005 Mobile edition is installd and if so how to uninstall it.

I want to do it all automatcally in my upgrade utility because my customers do not know to do it manually by theself.

Second I want to know if I have to use the Sql server 2005 Compact edition Uprade tool to upgrade my clients old databases because the now application works ok without Upgrading the database.



Thanks

Ofer Ebert

View 7 Replies View Related

Add A New Data Source To A SQL Server Compact Edition

Feb 21, 2007

I have installed SQL Server 2005 CE on my computer, but when I try to add a data connection to a CE database in Visual Studio 2005, I cannot find the option "SQL Server 2005 Combact Edition". Why?

View 5 Replies View Related

The Function Is Not Recognized By SQl Server Compact Edition

Sep 8, 2007



Unfortunatly this appers when i am trying to execute the following Query :


SELECT CurrentDate AS EXPR2
FROM [Date]
WHERE (DAy(CurrentDate) = 2)

It seems it doesn't support the (Day) function...Is there any solution or work around for that ?

View 1 Replies View Related

Is This Correct Forum For SQL Server Compact Edition ( Formerly Everywhere )

Jan 1, 2007

Hi,

I am looking for help ( at beginnners level ) in the use of the newly released / promoted SQL Server Compact Edition (what used to SSEv ).

I have a single user desktop application - not PDA / mobile, which uses JET database today & I need to convert it to current databse as JET is no longer supported under Vista. I understand that it is SQL Server Compact edition. My application is native c++ with no .NET and I would like to keep it that way. Can someone point me to examples, documentation, or any help which will get me going?

Currently, I am connecting to the JET database using ADO and a connection string ( again ADO, not ADO.NET ). Is it just a matter of changing the connection string and making sure that the righ dlls are included and registered?

Thanks in advance.

View 6 Replies View Related

Creating A Local SQL Server Compact Edition DB

Jan 25, 2007

Hi All ...

I'm setting up replication for the 1st time following the steps in the Books Online to get it up and running:


ms-help://MS.SSCE.v31.EN/ssmmain3/html/5a82aa7a-41a3-4246-a01a-2b1e4b2fdfe9.htm.
Anyhow, I get down to the section labeled - Create a new SQL Server Compact Edition database and am having a problem.  I open SQL Server Management Studio as instructed.  I click Connect and then am supposed to select SQL Server Compact Edition - yet can't find that option.
And, yes, I've installed Compact Edition on my development laptop.  So, how do I get this option so that I can create the local DB for Compact Edition and continue development?
UPDATE:
Ok, duh moment, I have SQL Server Management Studio Express loaded on my laptop, so did not have the option.  I've attempted to uninstall SQL Server Management Studio Express and install the full version from the SQL Server CDs.  However, when I go to install the full version it tells me that the management tools are already installed and won't let me install anything.  So, how do I get around this so that I can install full version of SQL Server Management Studio and then get the option to connect to the SQL Server Compact Edition?
Any help will be appreciated.
UPDATE 2:
Ok, figured it out.  You can't just uninstall SQL Server Management Studio express, you must go in to Add/Remove Programs, SQL Server 2005, Change.  Then select to uninstall the Workstation components.  Then you can go use the SQL Server install discs to install the full blown SQL Server Management Studio along with the other Workstation components.
Thanks ...
David L. Collison
   Any day above ground is a good day!

View 1 Replies View Related

SQL Server Compact Edition/ Foreign Key Did Not Show

May 29, 2007

Hi,



I have tried to convert my SQL Server Express Database file to SQL Server Compact Edition database file and it successfully. But I have some problem with the FK, I could not see the FK symbol in my new SQL Server Compact Edition database file. So i tried another method to implement the FK which is this code of line here



ALTER TABLE EQMetaData ADD CONSTRAINT Reference FOREIGN KEY ([EQID]) REFERENCES Equipments ([ID])



The second method also has no error but I could not see any FK show. Does anyone has this problem? Any suggestion to solve it? Please do share with me.



Thanks,

Bombie



ps: I attached to sreen shots of my DB, 1 is (SQL Express DB) and another is SQL Compact DB.

http://www.fileden.com/files/2007/5/24/1109807/SQLExpress.png

http://www.fileden.com/files/2007/5/24/1109807/SQLCompactEdition.png

View 1 Replies View Related

Examples Of OleDb With SQL Server Compact Edition

Jul 31, 2007

Hello,

My C# .NET application is currently using the System.Data.OleDb namespace to access SQL Server 2000 and SQL Server Express databases. I would like to begin using SQL Server Compact Edition to access a local database that has the same structure as the others. I'd like to use the same code regardless of the data source, so I would prefer to use System.Data.OleDb instead System.Data.SqlServerCe.

Where can I find examples of the use of System.Data.OleDb with SQL Server Compact Edition? Some of the specific questions I have are:

1.) How do I build the connection string for the OleDbConnection object?
2.) What are the limitations, if any, of using OleDb instead of SqlServerCe?

I will appreciate any help you can provide.

Thank you,

WTW

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved