Does SELECT @@identity works with in SQL Server compact edition? I have tried in SQL management sql query. It does work however when i use in VS.NET 2005 / Orcas beta1 , the generated tableAdapter does not recongize the syntax. So any workaround with it ? or any alternative that i can return the new inserted ID in my application.
Thanks.
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
Hi,
Can anyone tell me please how do I select top 10 rows in SQL Server Compact Edition 3.0
I checked on the following link of microsoft :
http://msdn2.microsoft.com/en-us/library/ms173340.aspx
This link says that TOP keyword is available in SQL Server Compact Edition. However when I tried it does not work.
I know for sure that the TOP keyword has been added in the SQL Server Compact Edition 3.5 beta version.
http://download.microsoft.com/download/e/0/2/e0221995-bb57-44c6-a3c6-58ce85db1c7f/ReadmeSSCE35.htm
But it is not there in SQL Server Compact Edition 3.0. Can anyone suggest me a way out of this?
Is there any way wherein I can select either few rows from the top or select rows starting from a particular row number to another row number .i.e say for example all rows between row number 100 to row number 2000.
Hi there,
i've tried using the SELECT SQL sentence on PPC with UNION and INNER JOIN in combination with DATEDIFF function which works fine on ordinary SQL but obviously does not work on compact edition. Is there some workaround?
SQL sentence that works:
Code Snippet
SELECT * FROM
(
SELECT 'O' Type, O.Name , OC.Name Contact, Birthday FROM OutletContact OC
INNER JOIN Outlet O ON OC.OutletID=O.OutletID
UNION
SELECT 'W' Type, W.Name,WC.Name Contact, Birthday FROM WholesalerContact WC
INNER JOIN Wholesaler W ON W.WholesalerID=WC.WholesalerID
) S
WHERE Birthday IS NOT NULL AND (DATEDIFF(day,GETDATE(),Birthday) BETWEEN 0 AND 14)
Thanks for any hint or solution to my problem,
Gorazd
Hi,
we are using a custom persistence framework on an SQL Server Compact Edition (3.5) database. It might occur, that a class gets persisted into a table having only a single IDENTITY column. Even worse, there may be additional columns in the database the persistence layer is not aware of.
I'm now looking for a way to insert rows into that kind of table without specifying any column values. In SQL-Server 2005 (also Express edition), there is a form
INSERT INTO table DEFAULT VALUES;
which does the job. Unfortunately, this construct doesn't seem to be supported by the Compact Edition.
Any suggestions? Many thanks in advance!
Sincerly
Martin Stettner
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)
-----------------------------------------------------------------------------
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
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?
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
Is there a way to reseed the Identity column in SQL Server Compact Edition? The following command does not appear to work DBCC CHECKIDENT (Table_Name, RESEED, 0) and I cannot seem to TRUNCATE the table either. Not sure if table truncation is even supported.
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
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
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.
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).
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.
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();
}
}
}
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
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
------------------------------
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!
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
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.
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
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
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?
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 ?
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.
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!
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
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
In my IPAQ, I have been using SQL CE for databases with various sizes without any problem. I am creating the databases on my desktop using VS 2005. After I moved to VISTA, I have upgraded my VS 2005 to SP1 and SQL CE to 3.1. My databases which were created before worked without any problem. After I have created my databases via 3.1 on the desktop and moved them to Mobile, I had problems.
1. I specify Max database size parameter as the size of the database
2. If the size of the database is smaller than 16 then I specify 128
3. If the database is old version then program runs without any problems whatever the database size is
4. If the database is created with 3.1 and size is small (20MB, 60MB, etc) no problems arise
5. Ä°f the databse is created with 3.1 and size is large (133MB, 174MB) then dbconnection.Open() command runs indefinitely and program hangs up .
My IPAQ runs "Microsoft Pocket PC Version 4.20.1081" and desktop runs VISTA Home Premium. I have installed VS 2005 SP1.
Thanks for any help
Hi
Can we use Top Clause in the Select statement while using SQL Server 2005 Compact Edition. If not, is there any other workaround available to achieve same results.
Regards,
Salman Shehbaz.
Hello All,
I am migrating from MSDE to Sql Server Comapct Edition.I want to how will it affect the code and how large the changes will be. For example will i need to change only the connection string or if some of the methods used by MSDE or not available in the CE version. Any information and ideas reagrding this will be useful.
Thanks & Regards
Keerti Somasundaram
Does anyone have idea how to connect SCE 3.1 with Orcas?
I just can't find any example