No one answered in another group, please help.
Using access 2000 /msde
I know how to compact the access project file (.adp), there's a menu choice
for that.
How do I compact the tables and stored procedures on the server? ( The .MDF
file)
I only have the DOS promp OSQL utility to work with.
thanks
Hi
We are checking VB 9 (Orcas).
we connected to database created under with sql server 7. with this code
Public cn As New ADODB.Connection
Public Sub OpenDB()
cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")
End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).
Rgds
Pramod
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 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'm trying to add an SQL Compact Edition database to my application running on a CE 6.0 platform that I am also developing. Unlike PB 5.0, I don't see sql CE listed as an option in the catalog and when I try to run my application I get a pInvoke sqlceme30.dll error. I have found a number of references to this same issue elsewhere but no real good solutions. Most seem to point to the cab files not being deployed. I am thinking that I should have the necessary support files deployed in the CE image and I have downloaded and installed every sql CE version/update that I can find but none of them seem to add support to PB 6.0.
I am trying to add the cab files manually but I would appreciate any suggestions if there is a better solution............ Thanks
Hi,
Is SQL Server Compact Editon 3.1 supported on Windows CE 6.0?
When I install the cab file sqlce30.wce5.armv4i.CAB in CE 6.0 it says that it might not be compatible. If I continue anyway it seems to work fine, but only the first time the application starts and accesses the database. When restaring the application it fails to connect to the database until I have reinstalled the cab file.
Any clues about this?
Thanks!
/ Joel
Hi,
I have an application where I need a desktop Application to manage the data and I have PDA application which talks to RFID and gathers the data. I am a bit confused if i can have only one database which can work both on PDA and Desktop. Can you please help me decide if i should use compact or express for this purpose. Also I might have to use both compact and Express but is there a way to have common database for both where they can be replication and easily synchronised.
Help is much appreciated.
Regards
Trushar
Hi,
I am wondering why a database that was 2Gb in size would come down to just 300Mb when I copy all the data from the origional database into a blank new one.
I ran a database shrink on the origional database but that only reduced it from 2.1 Gb to 2Gb.
I was shocked to see the size difference when I copied the data.
As far as I can tell the copied database still contains all the records of the origional.
I remember that MSAccess had a Compact function that literally copied all the data from one databse into a new empty one - is there the equivalent for SQL?
Any thoughts?
Thanks
Hi,I just deleted about 1 million records from a SQL Server 2000 database. Iaccess it using Access 2000.I have Compact and Repair available in the adp under Tools. Should I do thatfrom Access? Will it not mess anything up?Thanks!J~
View 2 Replies View RelatedIs there a stored procedure that allow the compact database programmaticallyin SQL Server?
View 2 Replies View RelatedCan SQL Server Compact Edition do RDA with SQL Express? or I need to have SQL Server 2005(standard) instead of SQL Express? I will use RDA to synchronize the Compact Edition database on the phone and SQL Server database on desktop.
Thanks!
I am trying to make a simple example like sql management studio but stuck in the get table names part :) in first step. are there any easy way to get just table names from sdf file ?
I have tried to use SMO but no success.
Regards.
I have VS2008 (9.0.21022.8 RTM) and I cannot get SQL Compact 3.5 to work with it. Whenever I attempt to open a compact edition database, I get a message that "The operation cannot complete, click OK on the "Package Load Failure" dialog, reinstall SQL Server Compact 3.5 and then from the command line run devenv /resetskippkgs. I've tried that twice and no joy. I can connect and work just fine with SSMS 2005, but I cannot get it to work in VS2008.
Also when in VS2008 and I go to Server Explorer | Data Connections | Add Connection, I do not have Microsoft SQL Server Compact 3.5 in the list.
Any suggestions? Thanks.
-John
I've downloaded and installed SQL Compact Edition. When I go to Access to set up a project (or to use the upsizing wizard) the software doesn't see the Server on my computer. No doubt I'm missing some very simple step. Although the compact server is installed, there's no program file to run, so I don't see how to get into the server software in order to set up a database or project that I can link to from Access.
I've also downloaded and installed Microsoft.net. As with server, the files are in place but there's no program file to execute.
I am trying to make an asp.net application that will run from the SQL Compact database.
To deploy the application we changed from a full path Data Source="C:inetpubappasdf.sdf"
to
Data Source="|DataDirectory|asdf.sdf"
This returns:
Illegal Character in Path
So I switched to having VS make the path for me
Data Source=".App_Dataasdf.sdf"
and got
The path is not valid. Check the directory for the database. [ Path = .App_DataPDQ_Test_CE.sdf
Is there ANYWAY to use a relative path for the SQL Compact Connection string?
Im using SQL Compact 3.1 and have created a desktop application
Can anybody tell me if there are any reporting fearures compatable
How reliable the SQL Compact 3.5 is?
What I need is to make sure that in case if my Windows CE based device lost power supply my SQL Compact 3.5 database will not be corrupted and I can read data from it.
Has anybody any experience in this area?
This is critical requirement for our project and I want to know it is feasible or not.
Here's the Active X Script I'm trying to migrate into an SSIS task:
Function Main()
Dim Engine, dbPath
dbPath = "c:path..."
Set Engine = CreateObject("JRO.JetEngine")
Main = DTSTaskExecResult_Success
Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath &
"database_UnCompress.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath &
"testdatabase.mdb"
End Function
I have problems in migrating. Here are the questions:
1. Is the ShrinkDatabase task the SSIS equivalent of this script? If so, I'm having problems creating a new connection since it is an mdb file stored on local computer and not on a server. Is there a workaround on this?
2. If I have to use the script task, I use this codes:
Set Engine = CreateObject("DAO.DBEngine.35")
Engine.CompactDatabase "C:.path...database_UnCompress.mdb", "C:path... estdatabase.mdb"
or
Set Engine = CreateObject("JRO.JetEngine")
Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pathdatabase.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pathcompacted_database.mdb"
Both produce the same error: Option Strict On disallows late binding. Any suggestions?
3. I also tried to use the Execute SQL Task, using dbcc shrinkdatabase. But I seem lost again in creating a connection. Should I consider "database_UnCompress.mdb" as flat file source?
Any help deeply appreciated. Thanks.
Hi,
Im working in a project that uses sql server compact. While migrating some data from another database I needed to "Turn off" the identity insert :
SET IDENTITY_INSERT <tablename> OFF
and set it back to "ON" after the migration was completed. Unfortunately SQL Server Compact is giving me the following error:
There was an error parsing the query. [ Token line number = 1,Token line offset = 5,Token in error = @@IDENTITY_INSERT ]
Im i doing something wrong or this instruction is not supported by the Compact edition.
Does anybody knows another way to do this?
Thank you
Alexander75
Hi everyone,
We are replicating SQL Server Compact and SQL Server 2008. My understanding is that SQL Server 2008 can only replicate with Compact 3.5 SP1, not Compact 3.5.
I have not been able to locate a download fromMicrosoft for SQL Compact 3.5 SP1. The download that is available is for Compact 3.5 (without the SP1).
Does anyone know where I can get the SP1 download?
Thanks
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?
Hi,
We have just installed visual studio 2008 for a windows mobile application development. This application requires a database also. VS 2008 installs sql server 2005 express edition and the sql server compact edition 3.5. We installed sql server management studio but this is for the express edition only. Please let us know how to use a similar tool for compact edition, we could not find any suitable for the same.
Regards
you can, with a dataset do something like myDataSet.WriteXml(m_XmlFile, XmlWriteMode.IgnoreSchema) and get XML for a record....
is it possible to do something like that with SQLserverCeresultset?
i know i could probably loop thru the columns and create the xml manually... but using somethinglike writexml will give better performance?
right now im not using anything from the XML class... from my previous exp with using XML classes on the Compact framework gives slow performance...
I'm an Access man moving towards SQL Server and I'm interested in knowing if there is a utility for my SQL Server version 7 database that is similar to Access' Compact and Repair utility? I'd like a recommendation from a guru on what Prevenatative Maintenance measures I should be running daily/weekly/monthly etc...
Thanks in advance.
dog
I want to use function "Compact and repair database" in SQL Server2000 which like function Access 2003.
How can i do ?
Thank you very much.
I want to access to a SQL Compact database with an application develope with Visual Basic ans using ADO (not ADO .Net). Is it possible and how ?
Thank You.
I am using SQL Server Compact Edition under ASP.NET. I am aware of the limitations and warnings from Microsoft for SSCE under ASP.NET, but this app is designed as a desktop deployed ASP.NET application running under the Cassini web browser. I wanted to use SQL Server Compact because of the RDA capabilities with SQL Server without the overhead of installing SQL Server Express. There would be 1-3 users at most running the application. SSCE seemed to make the most sense.
That being said, I have everything working fine except for this. I have added several SQLDataSource controls to several web forms and then I have GridViews bound to these controls. I like using the controls because of the built in sorting, grouping and updating I can do. When I run this on my development machine, it runs fine. When I move to one of my clean test machines and install the app, the SQLDataSouce controls throw the following error:
Unable to find the requested .Net Framework Data Provider. It may not be installed
I have the System.Data.SqlServerCe.dll in the bin folder along with all of the files from the the SQLServer Compact 3.1 install, a reference to it in the web.config file etc. In fact, I have several other database related datasets and tableadapters that are created throughout the application and they all work fine and can access and display data from my sdf file. It seems to only be with the SQLDataSource controls.
Any help would be greatly appreciated.
I'm trying to start an application in C# with visual Studio 2008 and I want to connect it to a SQL CE 3.5 Database (local .sdf file).
I only found samples or How-to guides that use the wizard to add the datasource and the way dragging the dataset to the form. All things binded to the database where you don't have to do coding.
I don't want to have the binding navigator bar, I just want to use text box, date picker and buttons and Save that to the database myself. That way I think it will be more easy for me to validate or manipulate data before the insertion in the DB.
Some time ago a make an ASP.net that was doing same kind of thing with an Access DB...
Hope this can help to show what i really want...
(sorry for my bad english....)
Nick
Code Snippet
Private Sub btnAskSql_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAskSql.Click
lblMsg.Text = ""
Dim MyDS As New DataSet
'txtRequest.Text is a SQL command like Select * from.....
MyDS = SQLRequest(txtRequest.Text)
Try
DG01.DataSource = MyDS.Tables(0).DefaultView
DG01.DataKeyField = "ID"
DG01.DataBind()
Catch ex As Exception
lblMsg.Text = Err.Description
Finally
End Try
End Sub
Function SQLRequest(ByVal TheRequest As String) As DataSet
Dim _Con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=" & Server.MapPath("Gifts.mdb") & ";")
Dim selectCMD As OleDbCommand = New OleDbCommand(TheRequest, _Con)
selectCMD.CommandTimeout = 30
Dim custDA As OleDbDataAdapter = New OleDbDataAdapter
custDA.SelectCommand = selectCMD
Dim TheDS1 As New DataSet
Try
custDA.Fill(TheDS1, "Request")
Catch ex As Exception
'oups
lblMsg.Text = Err.Description
Finally
_Con.Close()
End Try
Return TheDS1
End Function
Hi all.
We are developing a desktop windows forms app that uses tha database as storage for application configuration.
It may be used by one user locally OR used locally by multiple but sharing the database.
Now, i'm really sure that I have read that sharing the .sdf file over a network is supported and thus have started developing against the 3.5 compact db (sdf file).
But when testing this scenario we get a message that sharing over network is not supported. I'm really surprised and frankly puzzled since I know I have read about this being supported.
So, can someone more into this subject exlpain to this to me? Is it supported, and if not, should we use the express version instead?
Also, if we have to change strategy, is there an easy migration path regarding development (app. is not even in beta stage so no migrations will be necessary with customers.).
Thankful for any help since this might cause a lot of extra work...
If this leads down the synchronization path, could someone please explain how this is set up. Is it one "master" that acts as a publisher?
If we would like to have the solution where several users access the same db-file (be it sdf or mdf), do we have any choice here?
/Regards
What really changed from SQL Mobile to SQL Compact besides allowing the database to run on any desktop? Is there a document somewhere explaining the differences, I did not see anything?
I just changed my development machine over to SP1 and wondered what code I should be changing.
I am filling the database from my C++ Desktop app using ADO using the OLEDB provider Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 and using System.Data.SqlServerCe in my C# mobile app. Is that OLE provider valid with the new version or should it be *.COMPACT.3.1?
I thought there was now suppose to be some sort of automatic compaction, but I did not notice any new properties.
I would appreciate any insight into the changes.
Thanks,
Juan Foegen
i had read information about sce and i had not unsderstood a little thing:
is it possible or not to use a dataset with that version of sql server? i have a class that access the database with some functions and one of then return a dataset. the dataset is not to be used because it does not make sense with sql server compact edition or it cannot by use at all cause sql server compact edition does not support it?
thkx and by the way i think that it's a great product!
I am considering using SQL Compact in a new project, but during my testing I run into the weirdest errors.
I don't want to use the specialized SqlCeConnection, but rather OleDbConnection so the application supports any database (theoretically).
I cannot get it to work with datasets though. In my small testapp, I can create tables, insert data and get data with raw sql sentences and OleDbCommands. But when I try to use a Dataset with DataAdapters, then I receive weird errors like:
When I run DataAdapter.Update:
System.Data.OleDb.OleDbException was caught
Message="The given type name was unrecognized. [,,,,,]"
Source="Microsoft SQL Server 2005 Everywhere Edition OLE DB Provider"
ErrorCode=-2147217872
When I try to Configure a DataTable in the datasert-designer:
"Multi-step OleDb operation generated errors. Check each OLE DB status value, if available. No work was done."
Everything works perfectly with Access and SQL Server with the same dataset.
Is it possible to run SQL Server Compact Edition as a standalone application from a DVD?
i.e. it would not leave anything installed on the users computer after the DVD was ejected.