SQLCE 3.5 For X86 CE 4.2 Redistributable
Jan 31, 2008
Hi,
We have over 1000 terminals running CE 4.2 on an x86 cpu currently using SQLCE 3.1.
We have just upgraded to VS 2008 and found the projects have been upgraded to reference SQL CE 3.5 - this is great, as we wish to use things like TOP etc.
However, all the distributable packages only include CAB files for CE 4.2 for the ARM Processor, or CE 5.0 for the x86. Is there a CAB package available for CE 4.2 for the x86 CPU? (please...)
Even just the relevant .DLL files would be fine as we repackage them ourselves anyway.
Thanks.
View 1 Replies
ADVERTISEMENT
Feb 6, 2006
I am currently upgrading our ppc app (written in .net 2003) to .net 2005 and from sqlce 2.0 to 3.0. The new application runs out memory(storage) when handling lots of data transactions (both in case of using sqlcedatareader, and dataset ). There is no memory leak issue here, sqlce 3.0 simply uses a lot more (3 times more) memory than sqlce 2.0.
Our applicaton runs fine using sqlce 2.0 and .net 2003, but fail due to memory shortage
with the upgrades(which has the same code). Anyone can shed some lights on this issue?
View 3 Replies
View Related
May 13, 2006
My company wants to redistribute SQL Express with our product. I have not been able to figure out what is redistributable. Is it just the SQL Express package (SQLEXPR.exe) or is one also allowed to distribute the advanced package (SQLEXPR_ADV.exe)?
Thanks!
View 1 Replies
View Related
Mar 16, 2007
SQL Server 2005 Express (no sp) is 53.5 MB
http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en
SQL Server 2005 Express SP2 is 36.5 MB
http://msdn.microsoft.com/vstudio/express/sql/download/
That's a diff in size of almost 20 MB. How can the SP2 be so much smaller?
View 1 Replies
View Related
Aug 28, 2007
Hi.
I've been tasked with creating an installer that will either install SQL Express or connect to an existing SQL server.
Then I'm to run an .sql script to initialize a new database.
I'm using SSEUtil.exe as there will be no SQLCMD if the existing SQL server is on a remote machine.
Can I package SSEUtil.exe into my installer? Is this legal?
If not, is there a standard SQL Server client I can use to achieve this?
TIA,
lushdog
View 1 Replies
View Related
Feb 17, 2008
Does the Redistributable Package need to be installed when when calling reports in remote mode? If so, does it need to be installed on the SQL server where reporting services is installed or just on the web server that calls the reports or both? Also, since the SQL server has the reporting services version of Visual Studio, does that version of Visual Studio need to be updated to SP1?
View 3 Replies
View Related
Apr 25, 2006
Is SSMSE Redistributable?
View 1 Replies
View Related
Dec 29, 2006
Hi
Everyone. I see that Visual Studio 2005 SP1 is out and includes an updated
ReportViewer control. Is there an update to the ReportViewer
Redistributable with those same fixes? Our product installs this
redistributable silently, and we render reports locally (i.e. RDLC), so
installing the full Visual Studio service pack would not help us (and installing just the assemblies would not either, since the Redistributable install seems to do other things "under the hood."
Thanks for your help!
Erik
View 3 Replies
View Related
Jun 9, 2006
Does anyone have any instructions on how to go about uprading a .sdf file
from sqlce 2.0 to sqlce 3.0?
I found this on an msdn website
(link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx) but
as you can see its very lacking on detail. (I included the link and content
referring to upgrading the database files so you won't have to go to the link
to see the part referring to upgrading the database.) I tried to run the upgrade.exe on my device but it doesn't explain how you're supposed to point it to the .sdf that you are trying to update. Here is the content on the above web page.
Upgrading Database Files
You can upgrade a database created with an earlier version of SQL Server CE
2.0 to a database created with SQL Server Mobile by using the SQL Server
Mobile Database Upgrade tool (upgrade.exe). The Database Upgrade tool runs on
a smart device.
When you run the SQL Server Mobile Database Upgrade tool, the new SQL Server
Mobile database is created on the smart device. The new database, with the
file name extension .sdf, contains all the data that was in the source
database. You need to reinitialize the upgraded database to continue using it
for replication.
Note: If you are using replication or remote data access (RDA) as a
connectivity solution before upgrading to SQL Server Mobile, you must
synchronize the source SQL Server CE database (subscription database) with
the SQL Server database (Publisher). The reason for synchronizing before
upgrading to SQL Server Mobile is to ensure that any changes that exist in
the tables on the SQL Server CE database are updated on the SQL Server
database, because after the upgrade you must resubscribe or repull using the
new database.
View 3 Replies
View Related
Oct 11, 2006
I presently run on my server SQL SERVER CE 2.0 and want to install, in addition on SQL Server 2.0, SQL Server Mobile 2005.
Is there a procedure to have both installed and running on a computer?
Thanks!
Marco
View 2 Replies
View Related
Oct 9, 2007
I wrote program which connect to some remote MS SQL Server 2005, create SSIS package and store it to drive. Also it have ability to load SSIS package from drive, connect to server, load the SSIS package to specified server and execute it. Obviously, I used references to SSIS dlls in program. Question is - is SQL2005 necessary to be installed on computer where I execute the program? Since the program works with remote SQL Servers, I think what only some dlls is necessary for the program. Is it so?
View 12 Replies
View Related
Dec 20, 2006
Hi,
Can any body tell me whether SQL Express with advanced services is availabe as a redistributable so that i could package it up with my application. Basically i need to supply different reports with my application for which i dont want to use any Crystal Reports type of thing. Moreover i also want such kind of reports available on the net. Please tell me how can i do that?
Regards,
Wasif Ehsan.
View 1 Replies
View Related
Oct 30, 2006
I noticed that Microsoft gives license to redistribute SQL Server Express as part of an application (though we have to register for this - http://www.microsoft.com/sql/editions/express/howtobuy.mspx).
So we would like to take advantage of this, and redistribute SQL Server Express 2005 as part of our WinForms application (using the method described http://blogs.msdn.com/sqlexpress/archive/2006/09/20/763956.aspx or http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/emsqlexcustapp.asp)
My Question is: If we perform a silent install on the client machine (included with the installation of our application), are our end-users required to register Sql Server Express in order to use it? From this page (http://msdn.microsoft.com/vstudio/express/register/) it appears that in order to use an Express version for longer than 30 days, one is required to register it. However, requiring our clients to register their version of Express kind of defeats the purpose of our using Express as our database format. We need a database that we can distribute with our application, that the end-users can use without having to register.
So is the redistribution license enough (in order that the end-users do not have to register their individual copies)? Or will the end-users also have to register their copies (in which case we probably cannot use SQL Express)?
View 3 Replies
View Related
Jan 26, 2007
Where do I find the setup files needed to redistribute sql server express installation files? I downloaded the SQLEXPR_ADV.EXE but the files disappear as soon as you cancel the installation.
I need the sql server setup files to package with my program fr distribution.
THANKS SO MUCH
View 8 Replies
View Related
May 23, 2007
Can somebody please help answering this question?
I'm planning to consider writing a SSIS package for a new project that requires downloading large chunk of data and transform into the diverse databases such as MS SQL or Oracle depending on the Client's Datbase.
For the clients having SQL Server installed at their end, i had no issues in deploying this package on their server and run it in their licensed instance.
What should be the case for others having Oracle database? Wouldn't installing the SQL 2005 client tools install the necessary run-time services for running SSIS packages? What i understood from the MSDN library (http://msdn2.microsoft.com/en-us/library/ms403355.aspx) is that there's no run-time support available for running the SSIS packages (unlike DTS run-time support) in production environment!
Would that mean that it requires a SQL Standard edition, at minimum, (as Integration Services is OOTB from Standard Edition onwards) to be installed at the production site to run this package?
If so, the client wouldn't be ready (which is fair too) to buy the new license just to run this package. Is there any work-around/suggestions for this case?
If not, can somebody please point me to the right location where i can download the run-time support for running SSIS packages?
Any thoughts on this is highly appreciated.
Thanks for your time.
~Sagar
View 6 Replies
View Related
Jan 17, 2008
I am doing drillthrough from ReportA to ReportB via the Date field on ReportA. In Report Manager, all is well. However, when run through a custom app using asp.net and the report viewer control, the behavior was erratic. sometimes it would work. sometimes it would merely bring up the ReportA again and i would have to click Date again and then it would work.
a coworker recommended the Report Viewer fix http://support.microsoft.com/kb/933137. Since the redistributable was not present in Add/Remove programs on my test box, i installed the full version. I then started up the .net app in debug and ran ReportA and drilled through to ReportB several times and could not make it fail. I was happy.
Since the redistributable was not present on the production box, i installed the full install there as well. However, the erratic report viewer behavior continued.
I decided to try runnign ReportB directly instead of via the drill through from ReportA. ReportB had always run perfectly on its own. When i try to use the graphical date selector control, the results are different depending on the machine I use.
1. If i am using my test box, and i run ReportB directly via the app in debug mode, i get a runtime error indicating Microsoft JScript runtime error: Object required. It then points to Reserved.ReportViewerWebControl.axd at the GetObjectPosition(obj) function.
2. If i am using my test box and go out to the live production website, i get the same runtime error.
3. If i am using another machine and go out to the live production website, the data selector control merely seems to refresh the report. This is the same behavior i get when using the production server and going out to the live website.
The redistributable has been uninstalled from both the test box and the production box. This did not change the behavior described above.
All of the Microsoft.ReportViewer items in C:Windowsassembly indicate version 8.0.0.0.
Any help would be grand. Also, please let me know if I should cross post this in the .Net forums.
Thank you.
View 5 Replies
View Related
May 16, 2007
It is possible to upgrade existing SqlCE to Sql 2k5 database? Or just import CE database to import data model structure and data?
View 1 Replies
View Related
Dec 12, 2007
My app is working on my local system with the vs2008 development server. It's an asp.net app and I added the line:
AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
So it works fine on my system. But I can't get it to work on shared hosting. I have uploaded all the sqlce 3.5 dlls to the bin directory. I am stuck at the error:
Access to the database file is not allowed. [ File name = ]
There actually is a file name in the connection string, and I set the permissions wide open on App_Data to test this.
What are the .net framework requirements for sqlce 3.5? I can't find this info anywhere.
I know sqlce 3.5 is not recommended for asp.net, but it is not the main site database but is used for a setup database utility to be installed for a windows app.
View 3 Replies
View Related
Mar 21, 2007
Hi,
Could some one in copying data from Oracle to MS SQLCe, I have the entire table structure on SQLCe.
I want to do it progamatically, if there is tool which will do this activity I am also fine with that.
View 3 Replies
View Related
Apr 2, 2007
Hi i developed Wm5 PPC application with sqlce database. i Create Cab file when i install in my HP WM5 PPC that will showe the Message sqlcewm.dll missed. Please tell me 1)sqlce30.ppc.wce5.armv4i 2)sqlce30.wce5.armv4i 3)sqlce20.ppc.wce5.armv4i..Please Help me
View 1 Replies
View Related
Oct 23, 2007
In my homegrown data layer, I added the ability to do Order By Clauses.
I do one query with an Order By clause (all 6 records in the table retrieved).
Then I do a 2nd query without an Order By (36 of around 200 records in the table retrieved)
And I'm getting Native Exceptions.
ExceptionCode: 0xc00000000c (Null Pointer I believe)
ExceptionAddresss: 0x00c3703c (looks to be in sqlcese30.dll)
Reading: 0x00000005
I ran thru with the debugger, and am finding the error happening inside of a SQLDataReader.Read() call. It's trying to read the 14th of the 36 records that the query has found.
I am all but positive I'm not closing this database connection. The problem is happening while I'm looping off the reader data I just retrieved and in this query there was no ORDER BY clause.
I'm at a loss as to what to do about this. I'm not explicitly closing any database connections, and I'm getting the data right after performing the query.
View 1 Replies
View Related
Oct 4, 2007
Greetings,
I wrote a very simple C# console application which was designed to give us a rough idea on the performance and reliability of SQLCE (the source code without metrics has been posted to this group recently). What I've found is that there are major performance and reliability issues with SQLCE 3.0 as opposed to SQLCE 2.0. Whereas SQLCE 2.0 seems to be fairly consistent in terms of it's memory usage and the amount of time taken to insert rows into the table regardless of the size of the table (to a limit, after about 300,000 records it too has major performance issues), SQLCE 3.0 seems to slow down noticably and continually use more memory even after a few thousand records are inserted and actually crashes (consistently) after 25592 records are inserted!
What gives? Based on this it would seem that SQLCE 2.0 is far preferable for an unattended device that needs an uptime of over 30 days whilst constantly (several times per minute) inserting into the database.
Thanks for your thoughts on this...
View 6 Replies
View Related
Mar 3, 2008
I'm using SQL'05, VS'08 SQLCE 3.5 building VB.NET applications.
I'm using LocalDataCache to sync SQLCE and SQL'05
When I write a new record to SQLCE the corresoponding record in SQL'05 shows both LastEditDate and CreationDate values.
When I update the recored in SQLCE the LastEditDate gets updated, but CreationDate gets set to NULL.
Ideas?
David L.
View 8 Replies
View Related
Mar 20, 2007
Hi,
Could some one guide me hot copy tables/Data from SQL 2005 to Sql 2005 Compact Edition?
Thanks
View 3 Replies
View Related
Jan 3, 2007
Hello all,
I want to use SQLCE and WPF.
Can anyone direct me to some example code.
two way binding with a sqlceResultSet would be a great start.
(last inquiry was in Aug of 06)
Thanks
Mike (still trying to get the latest tech to work together) Greenway
View 6 Replies
View Related
Apr 13, 2007
Hi,
Does anybody know how to upgrade a SqlCE db(.sdf) file from Version 3.1 to 3.5?
And a URL where can I get related Info.
View 1 Replies
View Related
Nov 8, 2007
Last month , I have made a utility named sqlce viewer to help me manage sqlce 3.5 beta version databases .
The location is https://sourceforge.net/projects/sqlceviewer/
And now , I encounter a strange problem , need some help .
After user install this utility or run it standalone execute file .There has a error message poped before see the login in form . Even user has installed .net framework version 3.5 .
And if user has installed visual studio 2008 beta2 ,this problem will not existed .
This utility depend on these components :
1)WPF
2).net framework 3.5 beta
I don't know what's the reason clearly .
Anyone could give some advice are warm welcome.
View 2 Replies
View Related
May 31, 2007
can anyone tell me how to open/create a SQL Server 2005 Compact Edition database using SQL Server Management Studio Express?
cheers
View 5 Replies
View Related
Jul 30, 2007
I'm still having trouble deploying my Compact Edition application. The installation on other computers works, but if the program tries to start, i get the error message (translated from german):
"This Version of SQL Server 2005 Mobile Edition is not licencensed for productive use"
I always thought that there are no licence restriction with SQL Compact Edition.
Strangely the the programm works on some computers... as I think on all computers where Visual Studio is installed.
does that makes any sense to one of you?
thanks for any help,
Stefan
View 1 Replies
View Related
Jun 3, 2004
Problem encountered:
Error Code: -2147467259
Message: A call to SQL Server Reconciler failed. [,,,,,]
Minor Err. 29006
Source: Microsoft SQL Server 2000 Windows CE Edition
Any idea what could be the possible problem?
I have been trying to search thru the internet for a resolution but most of the guides are very brief about the configuration of the merge replication in mssql2000 server.
e.g. http://msdn.microsoft.com/msdnmag/issues/03/09/DataPoints/default.aspx
This link above its recommended by Microsoft, but still doesn't really helps.
Does anybody have a step-by-step guide on configuring the merge replication in mssql? With diagrams preferred.
-OR-
Is there anything wrong with these codes:
oRpl.Publisher = "HANBIN"; // HANBIN is my database server name
oRpl.PublisherLogin = "LHP";
oRpl.PublisherPassword = "<password>";
oRpl.InternetUrl = "http://hanbin/ssce/sscesa20.dll";
oRpl.InternetLogin = "IUSR_HANBIN";
oRpl.InternetPassword = ""; // do i need to put sth here?
oRpl.Subscriber = "CESubscriberTest"; // Any names will do?
oRpl.Publication = "testdbpub";
oRpl.PublisherDatabase = "testdb";
oRpl.Distributor = "HANBIN";
oRpl.DistributorLogin = "sa";
oRpl.DistributorPassword = "<password>";
Any help from any genious will greatly be appreciated.
Regards,
Hanbin
View 2 Replies
View Related
Apr 6, 2004
I’m using SQLCE and SQL Server2000 to replicate to a Pocket PC running PPC MS windows 2002. What I want to know is it possible to update my cab file on the PDA remotely?
Is it possible to install the cab file trough SQLCE?
View 1 Replies
View Related
Jan 17, 2008
Hi,
Can I use SqlCe v3.1 and SqlClient v2.0 in one .net application? (Note: I can't use RDA or replication. SqlClient read and write data in ON-LINE mode, SqlCe store and manipulate with data in OFF-LINE mode.)
View 4 Replies
View Related
Apr 20, 2007
MSDN has examples of deploying SQLCE privately for C# and VB.NET, but that doesn't seem to translate to C++. A .NET application just loads the assembly it needs from the local directory, but from what I can tell I need to use the OLE DB driver to use SQL CE in C++. The problem is that the OLE DB driver is a COM object that (presumably) needs to be registered.
Has anyone successfully used SQLCE from C++ without registering any COM objects? I'm thinking the only way to do that would be to call DllGetObject() on the DLL and get the object manually, but I've never done this so I'd hate to waste the time if there's an easier way, or if this won't work.
View 7 Replies
View Related
