CompactDatabase In ASP With SQL Server Microsoft SQL Server Compact
Jul 2, 2007
I've been playing around with Microsoft SQL Server Compact Edition
v3.1 as a posible replacement for the SQL Server CE 2.0 (can't
remember exactly what the called it). Its working pretty well. I
was able to connect to the database using the same recordset object,
ADODB.RecordSet and connection object, ADOCE.Connection.3.1. However
where I've run into trouble is when I try to compact the database.
This code works on 2.0.
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).
I'm looking for the sample application : IBuySpy Delivery Sample Application (SQL Server Compact). But I could not find this sample file anywhere. The only sample which is available in my local directory below is Northwind.sdf file C:Program FilesMicrosoft SQL Server Compact Editionv3.5Samples
The link in the Book Online is pointing to this URL below : http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en
I have a J2EE based web application. There is a requirement where user triggers a process to query a database, and the application needs to save the results to an SDF file (Microsoft SQL Server CE 2.0 / Microsoft SQL Server Compact Edition) database. I need JDBC driver for it, but could not find it anywhere. Please help. Also, if there is any alternate way to do this, please let me know.
I am using a Compact Framework 2.0 on a mobile 5.0 with a local Microsoft SQL Compact Edition 2005 database. The backend database is a Microsoft SQL Server 2005 and I am trying to pull a 45000 rows table (the table has 2 varchars(8) forming a primary key and an INTEGER column).
We are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using: public bool Replicate() { bool ret = true; SqlCeReplication repl = null; try { // Instantiate and configure SqlCeReplication object repl = new SqlCeReplication(); string dbFile = ........ repl.InternetUrl = this.InternetUrl; repl.InternetLogin = this.InternetLogin; repl.InternetPassword = this.InternetPassword; repl.Publisher = this.Publisher; repl.PublisherDatabase = this.PublisherDatabase; repl.PublisherLogin = this.PublisherLogin; repl.PublisherPassword = this.PublisherPassword; repl.Publication = this.Publication; repl.Subscriber = this.Subscriber; repl.SubscriberConnectionString ="Data Source=" +dbFile; if (!System.IO.File.Exists(dbFile)) { repl.AddSubscription(AddOption.CreateDatabase); } repl.Synchronize(); } IIS is configured, but in log on the server we've got this error: 2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgent
i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:
Microsoft SQL Server Management Studio Express Date: 19.04.2006 http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
but this one:
SQL Server Management Studio Express Service Pack 2 €“ CTP-Version Date: 19.12.2006 http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en
hope this helps.
Nihat
P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of SSMSe?
I need some advise/help how to deploy a small sql server compact 3.5 database on networkshare where about 8 people have access to it(install de client ) and can modify the database with aprox 3000 records. I'm using visual basic 2008 and created a compact database and filled it with one table of an export of an access database done with data port console. And created a new windows forms application and saved the project. Publish is not the problem but how too set it up...... There is not much info to find on how to get a sql server 3.5 database running on a network share. Who can help ???
Using VS 2008 I got a Windows Smart Device project targeting WM6 Standard and using .NET CF 3.5. I add a new database file = creating an empty Compact 3.5 database (creates an sdf-file in my project). Then create an empty dataset in the wizard (creates an xsd-file in my project). Then I add a couple of tables in the database. After that I want to use my earlier created dataset. I mark the xsd-file and looks in Poperties. I get the error when I try to change Custom Tool value from 'MSDataSetGenerator' to 'MSResultSetGenerator'. Why????
Hello, How are you? I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en. In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE?
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.
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
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
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server "
I keep getting this when trying to copy stored procs from one db to another on the same server. I am using the DTS wizard. I have been able to copy the tables but I need the sp's too, and there are too many to copy one at a time.
In VS 2005, when we choose database connection, we can choose one of the above. My question is in what situations should we choose MS SQL Server Database File (SqlClient), and when should we choose Microsoft SQL Server?
I want to deploy a standalone desktop application with a backend database. Which backend database should I should and which of the above connection should I choose?
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application. --------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I am looking forward to a native 64-bit file-based database solution on Microsoft Windows platform. And I don't know why Microsoft didn't release the native 64-bit solution for JET engine (MDB file).
So, before I using this light-weight and file-based version of SQL Server, I will like to ask the question that the 64-bit version has been put into develop schedule?
Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.
"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"
Is there anyone here who use "Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ? http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
i am using VS2005 Version 8.0.50727.762 (SP.050727-7600) and SQL Server 2005 SP2
Dear All,Access adp on sql-server 2000After upgrating to A2003 updating data with 1 perticular combobox causes theprogram to hangs without any error-msg.Traying to change te combobox recordsource i get this error:This version of Microsoft Access doesn't support design changes to theversion of Microsoft SQL Server your project is connected to. See theMicrosoft Office Update Web site for the latest information and downloads(on the Help menu, click Office on the Web). Your design changes will not besaved.The solution in :http://support.microsoft.com/defaul...kb;en-us;313298tolks about SP 'dt_verstamp007' but I have SP 'dt_verstamp006'What should I do.Is the failure of the combobox also caused by the absence of dt_verstamp007???Filip
I have a query that executes just fine except that it won't recognize varchar(255) ( or any other value within the () ) and if I leave it off like this: varchar, then it executes but it leaves that value as 1 and that is just not very useful for my purposes. This also happens with anything else that requires () to add length such as char(), or nvarchar(), etc... Any ideas?
I have a question about a problem that I cannot seem to tackle. I have installed the following programs on Windows Vista:
- SQL Server 2005 - Visual Studio 2008 - SQL Server Compact Edition 3.5 - SQL Server Compact Edition 3.5 Server Tools
I want to do the following:
1. I want to create a SQL Server Compact Edition 3.5 database in the SQL Server Management Studio 2. I want my SQL Express server in SQL Server 2005 to be a distributor and publisher
About 1. In SQL Server Management Studio I cannot choose SQL Server Compact Edition 3.5 . ABout 2. I tried to setup my server to be a distrubutor by running a stored procedure with the following name: sp_adddistributor. I get the following error: This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Trying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there. I have uninstall all of the Sql Ce stuff and reinstalled it. So I'm missing some key link. What are the magic incantations to get to first base?
I am having problems installing the SQL Server Compact Server Tools on my Vista laptop to allow me to connect my Mobile Device running SQL Server Compact directly to my SQL Server 2005 database through IIS.
I have done this successfully with an XP machine so I'm not sure if it is Vista problem or not.
I have installed SQL Server 2005 SP2. When I try to install the replication server tools (Sqlce30setupen.msi), in "System Configuration Check" window I get a failure on "SQL Server requirement" that says: "You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components" and the client components are full instaled in my computer.
I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases.
To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect.
To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:Program FilesMicrosoft SQL Server Compact Editionv3.1".
Is there perhaps an additional step that I left out to complete the installation?
Might I need an upgrade to some other components? My Management Studio Version is:
- Microsoft SQL Server Management Studio Express 9.00.2047.00
Which tool can I use for structure editing of SQL Server Compact 3.5 databases? I'm installed SQL Server Compact 3.5. I have SQL Server Management Studio Express which was installed with SQL Server 2005 Express. Unfortunately this SSMS can create and open only 3.1 databases.
I am using SQL Express 2005 server and sql compact edition for my PDA. For synchronization, which SQL Server 2005 Compact Edition Server Tools installation package do I use?
Is it Sqlce30setupen.msi or sql2kensp4.msi or sql2kensp3a.msi? I know for sql server 2005 its Sqlce30setupen.msi. Is it the same for the SQL Express 2005?
I am very new to SQL Compact. I am trying to create one database which can work on the desktop application and also on a pda application. I want to create the database but I am unable to start without Management Studio. Can you guide me to the right tools so that I can create database, view it and manage it use something like Management Studio Express.
Also one more question is if my database needs to be at both places on the desktop and on pda how can i synchronise them. PDA will take using c# application data from RFID scans and then i need to sync that database on the desktop so that reports and other info can be generated from the desktop c# application. How to do this?
Please can you guide me to any webcasts or labs so i can clarify my doubts about the design.
i tried to connect to a SQL Server Compact Database (version 3.5) with SQL Server Management Studio Express (Version 9.00.3042.00).
But i get the follwing error message (sorry, it's a german message):
..................................... Es kann keine Verbindung mit 'D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf' hergestellt werden.
Sie versuchen, auf eine ältere Version einer Datenbank von SQL Server Compact Edition zuzugreifen. Falls es sich um eine Datenbank von SQL Server CE 1.0 oder SQL Server CE 2.0 handelt, führen Sie 'upgrade.exe' aus. Falls es sich um eine Datenbank von SQL Server Compact Edition 3.0 oder höher handelt, führen Sie die Komprimierung und Reparatur aus. [ Db version = 3505053,Requested version = 3004180,File name = D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf ] (SQL Server Compact Edition ADO.NET Data Provider) .....................................
Is there a solution to manage Compact Databases in Version 3.5?
We are currently having a problem with a client running Vista business for a mobile application that uses SQLCE RDA with the Web Synchronization on IIS7.
I have run through the Configure Web Synchronization Wizard and it doesn't create a virtual directory. I manually create the virtual dir and point it to the new folder the Configure Web Synchronization Wizard created.
Browsing to the url "http://localhost/sqlce/sqlcesa30.dll" gives a valid test string.
Here is the ?diag response... SQL Server Mobile Server Agent Diagnostics 2007/03/20 15:39:49
General Information
Item Value
Server Name localhost
URL /sqlce/sqlcesa30.dll
Authentication Type Anonymous
Server Port 80
HTTPS off
Server Software Microsoft-IIS/7.0
Replication Allowed
RDA Allowed
Logging Level 3
Impersonation and Access Tests
Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0
SQL Server Mobile Modules Test
Module Status ErrorCode Version
SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0
SQLCESA30.DLL SUCCESS 0x0 3.0.5206.0
Reconciler Test
Reconciler Status ErrorCode
9.0 Database Reconciler SUCCESS 0x0
8.0 Database Reconciler SUCCESS 0x0
SQL Server Module Versions
Module Version
sqloledb.dll 6.0.6000.16386
9.0 replrec.dll 2005.90.3042.0
9.0 replprov.dll 2005.90.3042.0
9.0 msgprox.dll 2005.90.3042.0
8.0 replrec.dll 2000.80.2039.0
8.0 replprov.dll 2000.80.2039.0
8.0 msgprox.dll 2000.80.2039.0 When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLOLEDB ...
Which roughly translates to from the header file ...
#define SSCE_M_INCORRECTPROVIDERVERSION 29022 // The version of the Microsoft OLE DB Provider for SQL Server is not correct. Install MDAC 2.8 or later. [,,,Version,,]
When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLNCLI ...
HResult = -2147467259
Message = " [ 9 ]"
NativeError = 29022
numericErrorParameters = {9,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
A very similar error.
From this it seems that both SQLCE 2 and 3 seem to want MDAC 2.8+ drivers. The drivers installed with Vista for SQL Native client seem to be versioned 6.0.* and the required versioning would seem to need to be in line with MDAC 2.8.
Are there installable drivers to bump the versioning of SQLNCLI or SQLOLEDB upto MDAC 2.8+ levels?
Or is there an alternative that will make it possible to run SQLCE RDA apps with Vista as the SQLCE server (i.e. sqlcesa30.dll)?
