Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Upgrading SqlCE 3.1 To 3.5


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Upgrading From Sqlce 3.1 To 3.5 Questions
In the readme of v3.5, it mentions that if I use 3.5 to open a database file created by previous version, the version number will be updated to 3.5, so I opened it in c# and run some select statement, then I run the verify() command and here's what's returned:

 

Source      : d:Dataceguardian.sdf
Destination : n/a
Verifying - verMajor: 3, verMinor: 0, verBuild: 5300, verPoint: 0
Time - 2007-21-05 14:42:39.847

 

it seems the database file did not get updated to v3.5. Unless it's returning original info.

 

Then, I take this same database file and try to access from another project with v3.5 runtime + Enterprise Library, and it generates this error:

 

An exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in guardian.exe but was not handled in user code

Additional information: You are trying to access an older version of a SQL Server Compact Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later database, run Compact / Repair. [ Db version = 3505053,Requested version = 3004180,File name = D:Dataceguardian.sdf ]


I am confused. Shouldn't 3.5 opens it up regardless of what version it is?

 

WL

View Replies !   View Related
Upgrading Sqlce 2.0 Database To Sql Server For Mobile Database On Desktopn
can we upgrade a sqlce forgotten password database to sql server for mobile database on our desktop
 
 
Thanks & Regards
Mukesh Gupta

View Replies !   View Related
Sqlce 3.0 Vs Sqlce 2.0 Memory Issue
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 Replies !   View Related
SQLCE 2.0 And SQLCE 3.0, Both On Same Server
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 Replies !   View Related
How Do You Use The Upgrade.exe For Sqlce 2.0 To Sqlce 3.0?
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 Replies !   View Related
Sqlce 3.5 Won't Run On Asp.net
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 Replies !   View Related
SqlCE To SQL 2k5
It is possible to upgrade existing SqlCE to Sql 2k5 database? Or just import CE database to import data model structure and data?

View Replies !   View Related
SQLCE 3.5 Sync BUG
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 Replies !   View Related
SQLCE 3.5 For X86 CE 4.2 Redistributable
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 Replies !   View Related
Sqlce Utility Need Help
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 Replies !   View Related
NativeException In SQLCE?
 
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 Replies !   View Related
Is It Just Me Or Are There BIG Problems With SQLCE 3.0?
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 Replies !   View Related
SSMSE With SQLCE
can anyone tell me how to open/create a SQL Server 2005 Compact Edition database using SQL Server Management Studio Express?

cheers

View Replies !   View Related
SqlCe Not For Productive Use?
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 Replies !   View Related
Which SqlCe Cab File I Can Use
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 Replies !   View Related
SQL 2005 To SQLCe
Hi,

Could some one guide me hot copy tables/Data from SQL 2005 to Sql 2005 Compact Edition?

 

Thanks

 

View Replies !   View Related
Oracle To SQLCe
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 Replies !   View Related
SQLCE And WPF Examples?
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 Replies !   View Related
Merge Replicaiton With SqlCe
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 Replies !   View Related
Installing CAB Files Using SQLCe
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 Replies !   View Related
Subscribing To Two Publications On SQLCE
I have two publications on a SQL Server 2000 database.
I am able to create two subscriptions from another SQL Server 2000 database
and synchronize both in succession.

However when I try to repeat this going from SQL Server 2000 to SQLCE 2.0
it fails. The first goes OK. The second fails.
I get error 80004005, 28521 (The SQL Server CE database is already enabled for publication.
Is it possible to do what I am trying to do on CE?

The reason I have 2 publications is because the first is non-filtered and goes very fast via bcp files when reinitialized.
The second is dynamically filtered and not as fast. Breaking them up makes reinits go much faster.

My code is included below.

Thanks
Ed Santosusso
esantosusso@omicron.com

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

 // Create and initialize the Replication object
 hr = CoCreateInstance(CLSID_Replication, NULL, CLSCTX_INPROC_SERVER,   IID_ISSCEMerge, (LPVOID *)&CEMerge);
 CEMerge->put_InternetURL(L"http://myiisserver/sqlce20/sscesa20.dll");
 CEMerge->put_InternetLogin(L"<userid>");
 CEMerge->put_InternetPassword(L"<password>");
 CEMerge->put_Publisher(L"mysqlserver");
 CEMerge->put_PublisherDatabase(L"MyDataBase");

 CEMerge->put_Publication(L"Publication1");
 CEMerge->put_PublisherSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
 CEMerge->put_PublisherLogin(L"sa");
 CEMerge->put_PublisherPassword(L"mypassword");
 CEMerge->put_PublisherNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
 CEMerge->put_Subscriber(L"TestReplAndMerge");
 CEMerge->put_SubscriberConnectionString
  (L"Provider=microsoft.sqlserver.oledb.ce.2.0;Data Source=\mydatabase.sdf");
 CEMerge->put_Distributor(L"mysqlserver");
 CEMerge->put_DistributorNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
 CEMerge->put_DistributorSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
 CEMerge->put_DistributorLogin(L"sa");
 CEMerge->put_DistributorPassword(L"mypassword");
 CEMerge->put_HostName(L"some host name");
 CEMerge->put_ExchangeType((REPL_EXCHANGE_TYPE)BIDIRECTIONAL);
 CEMerge->put_Validate(NO_VALIDATION);


 bool NewFile = false;
 
 // see if we need a file


 if (FileExists(L"\mydatabase.sdf") == false)
 {
  hr = CEMerge->AddSubscription(CREATE_DATABASE);

  if (!SUCCEEDED(hr))
  {
   ShowMergeErrors(L"Add Subscription failed",CEMerge);
   return 0;
  }
  NewFile = true;
 }


 hr = CEMerge->Initialize();

 if (!SUCCEEDED(hr)) {
  ShowMergeErrors(L"Static Merge Initialize failed",CEMerge);
  return 0;
 }

 hr = CEMerge->Run();
 if (!SUCCEEDED(hr)) {
  ShowMergeErrors(L"Static Merge Run failed",CEMerge);
  return 0;
 }


 // Destroy the Replication object
 if (CEMerge)
  CEMerge->Release();

 

 // set up for Second Merge

 // Create and initialize the Replication object
 hr = CoCreateInstance(CLSID_Replication, NULL, CLSCTX_INPROC_SERVER, IID_ISSCEMerge, (LPVOID *)&CEMerge2);
 CEMerge2->put_InternetURL(L"http://myiisserver/sqlce20/sscesa20.dll");
 CEMerge2->put_InternetLogin(L"<userid>");
 CEMerge2->put_InternetPassword(L"<password>");
 CEMerge2->put_Publisher(L"mysqlserver");
 CEMerge2->put_PublisherDatabase(L"MyDataBase");

 CEMerge2->put_Publication(L"Publication2");
 CEMerge2->put_PublisherSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
 CEMerge2->put_PublisherLogin(L"sa");
 CEMerge2->put_PublisherPassword(L"mypassword");
 CEMerge2->put_PublisherNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
 CEMerge2->put_Subscriber(L"TestReplAndMerge");
 CEMerge2->put_SubscriberConnectionString
  (L"Provider=microsoft.sqlserver.oledb.ce.2.0;Data Source=\mydatabase.sdf");
 CEMerge2->put_Distributor(L"mysqlserver");
 CEMerge2->put_DistributorNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
 CEMerge2->put_DistributorSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
 CEMerge2->put_DistributorLogin(L"sa");
 CEMerge2->put_DistributorPassword(L"mypassword");
 CEMerge2->put_HostName(L"some host name");
 CEMerge2->put_ExchangeType((REPL_EXCHANGE_TYPE)BIDIRECTIONAL);
 CEMerge2->put_Validate(NO_VALIDATION);


 if (NewFile)
 {
  hr = CEMerge2->AddSubscription(EXISTING_DATABASE);

  if (!SUCCEEDED(hr))
  {
   ShowMergeErrors(L"Add Subscription failed",CEMerge2);
   return 0;
  }
 }


 hr = CEMerge2->Initialize();

 if (!SUCCEEDED(hr)) {
  ShowMergeErrors(L"Tech Merge Initialize failed",CEMerge2);
  return 0;
 }

 hr = CEMerge2->Run();
 if (!SUCCEEDED(hr)) {
  ShowMergeErrors(L"Tech Merge Run failed",CEMerge2);
  return 0;
 }


 // Destroy the Replication object
 if (CEMerge2)
  CEMerge2->Release();


 

View Replies !   View Related
This Query Is Not Working Against SqlCE 3.1
Hi,


I am unable to execute the following query against SqlCE 3.1.
Could someone guide me what is wrong.
 
 
SELECT CASE WHEN ISNULL(MAX(CONTENT_NUMBER)) THEN 0 ELSE MAX(CONTENT_NUMBER) END + 1
FROM PRELIMINARY_CODES WHERE EXAMID = '38D990D322C94B189FF12AF158AD7B06';
 
Error Message:
Major Error 0x80040E14, Minor Error 25501
> SELECT CASE WHEN ISNULL(MAX(CONTENT_NUMBER)) THEN 0 ELSE MAX(CONTENT_NUMBER) END + 1
FROM PRELIMINARY_CODES WHERE EXAMID = '38D990D322C94B189FF12AF158AD7B06'
There was an error parsing the query. [ Token line number = 1,Token line offset = 46,Token in error = THEN ]
 
 
But when I execute foloowing queries:
1) select MAX(CONTENT_NUMBER)from PRELIMINARY_CODES;
Result: NULL


2) select ISNULL(MAX(CONTENT_NUMBER))from PRELIMINARY_CODES;

Result: 1
 
 
Thanks
Sreenaiah

View Replies !   View Related
Cannot Find SQLCE 3.5 Database
 

hi,
   I am developing a PDA project using Windows CE 6.0
   I develop an Application using VS 2008 and create a database using SQLCE 3.5 in VS2008.
   I run the Application in Mobile 6 Emulator, it is correctly.
 
  When I integrate it in My Custom OS, there is an error to connect the SQLCE 3.5 Database.
 
  My CE 6.0 customed OS included: All 'File System and Data Store' Components.
  I also Include  the 7 DLL: in C:Program FilesMicrosoft SQL Server Compact EditionV3.5Deviceswce500armv4i
     -sqlcecompact35.dll
     -sqlceme35.dll
     -sqlceqp35.dll
     -sqlceca35.dll
     -sqlceer35EN.dll
     -sqlceoledb35.dll
     -sqlcese35.dll
 
Also, I include the three CAB Files:
   - sqlce.dev.ENU.wce5.armv4i.CAB
   - sqlce.wce5.armv4i.CAB
   - sqlce.repl.wce5.armv4i.CAB

 
 I first Run the three CAB files in My PDA Emulator.
 Then I run the Application located: Windows
 All the files I imported in my OS is located in Windows
 
   When I run my Application, there is an error prompted:
   "The Database file cannot be found. Check the Path to the database.
    [Data Source = WindowsTest.sdf]"
 
  I try to use The Query Analyer to open the DB:WindowsTest.sdf,
  The Error Message shown:
     Error: 0x8004005 E_FAIL
     Native Error: (25046)
     Interface definning error: IID_IDBInitialize
     Param 0 : 0
     Param 1 : 0
     Param 2 : 0
     Param 3 : WindowsTest.sdf
 
 I, then, create a database in my PDA Emulator using isqlw35.exe (Query Analyzer)
    and located in  WindowsTest2.sdf.
After create the Test2.sdf, I use the Query Analyzer to re-open it. It is correct with no error!
I use my Application to open the WindowsTest2.sdf, and it is correctly too!
 
Therefore, the problem would be: The SQLCE 3.5 database I created in VS2008, named 'Test.sdf'
cannot be opened in my customed ce 6.0 OS. However the database I created in my customed OS 6.0
emulator ,named 'Test2.sdf' works fine.
 
Is there any difference or what's wrong when I create a SQLCE 3.5 database and integrated in Windows CE 6.0???
 
 

View Replies !   View Related
Running The SQLCE SERVER
hi
I am new in SQLCE and I am trying to run SQLCE SERVER...
I have already downloaded the software and installed it as server on my computer...
I have checked the services running on my system but could not find SQLCE server, I don't know what is wrong with it and don't know what to do with SQLCE server   ..
I will be glad if any one would tell me what to do...
thanks.......

View Replies !   View Related
How To Append Dataset To Sqlce??
I'm having a bit of a problem figuring out how to pass a dataset to sqlce to be appended to a table.

I'm using the CSVDataAdapter.dll to import from a csv file. I'm able to load the data into a dataset but from there I'm having my problem. Since the recordset is not from my table that I want to write, how can I pass the recordset for appending?






Code Snippet

Dim ds = New DataSet()
        da = New CSVDataAdapter(apppath + "DBmyfile.csv", True)

        'Fills the recordset with CSV file information
        da.Fill(ds, "Newfile")

        'display in grid
        Me.DataGrid1.DataSource = ds.Tables("Newfile")

Could I use - USING?





Code Snippet

Using cmd As New SqlCeCommand("Newfile", conn)
        cmd.CommandType = CommandType.TableDirect

         'code to manipulate the resultset
        Using ds As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable)
End Using

View Replies !   View Related
SQLCE V3.5, VS2008 And Framework 2.0 -- Possible?
I was initially interested in building my small retail app on Framework 3.5, until just now when I saw the download size. I won't make a single sale with that as a prerequisite.
 
I would, however, like to use VS2008 for this. If I target Framework 2.0, will I still be able to use SQLCE v3.5? The new SET IDENTITY INSERT functionality is an absolute requirement. (Note: I haven't installed VS2008 yet--I'm still investigating options.)
 
Thanks!

View Replies !   View Related
How To Detect Whether Installed The Sqlce 3.5 RTM Or Not ?
How to Detect whether installed the sqlce 3.5 RTM or not ?

View Replies !   View Related
SqlCe &&amp; SqlClient In One Application
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 Replies !   View Related
SQLCE 3.5 Support For VS2005
Neither the SQLManagement Studio nor Visual Studio 2005 will open a 3.5 database. I understand that it's a "Orcas" technology but it works fine with vs2005 and Framework 2.0.  I'm currently using VS2005 with CE 3.5 and using Rafik's Sync services, support for 3,5 would be a great help for the XSD and query creation.

 

Does anyone know when broader support for 3.5 will be available?

 

View Replies !   View Related
Strange Problem With Sqlce 3.5
I used vs2008 team suite rtm and sqlce 3.5 .
When I connect to a sdf file which I created and used early in Vs2008 IDE Server Explorer.
There is a very strange problem.
When I test connection . it pop me OK . but when I click Ok to connect the sdf file really . It show me the error message
"The path is *****" .

Who know the reason ?

View Replies !   View Related
Random Crashing In SqlCE
I have a program that works perfectly...until it crashes.  It basically logs info into a SqlCE local file database. After a random time (15 seconds to ~5 minutes) it crashes with the following exception.  I cannot find much correleation in the code I've written, except that it seems to crash less often in debug mode...


-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.20706.1

System.Transactions Critical: 0 :
<TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical">
<TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier>
<Description>Unhandled exception</Description>
<Exception>
<ExceptionType>System.AccessViolationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
<Message>Attempted to read or write protected memory. This is often an indication that other memory is corrupt.</Message>
<StackTrace>
   at System.Data.SqlServerCe.NativeMethods.SafeRelease(IntPtr&amp;amp; ppUnknown)
   at System.Data.SqlServerCe.SqlCeCommand.ReleaseNativeInterfaces()
   at System.Data.SqlServerCe.SqlCeCommand.Dispose(Boolean disposing)
   at System.Data.SqlServerCe.SqlCeCommand.Finalize()
</StackTrace>
</Exception></TraceRecord>

View Replies !   View Related
Howto Import Into SQLCE 2K5 CE Db...
Can someone please suggest some quick way to import data into SQL 2005 CE tables from an SQL 2000 server db tables. 
 
Thanks
Rajesh

View Replies !   View Related
Can Not Run SSCE31VSTOOLS-ENU -&&> No DMA In ActiveSync, No SQLCE In VS !
I have the following problems:
 - in Active Sync 4.5 there is no DMA connection available
 - when selecting a DataSource in VS2005 I do not have SQL SERVER Compact Edition in the list
 
While testing this problem out, I found it has something to do with this update SSCE31VSTOOLS-ENU and SSCE31VSTOOLS-DEU. Both updates do not run. Instead I get a message that necessary files are missing or do not have the right version for updating.
 
How could I solve this problem? What is the right order to install this beasty patch?
 
Best greetings from Germany.

View Replies !   View Related
SqlCe Memory Issue
Hi all, I am querying an SqlCe Database on my PDA and noticed that the device is slowly running out of memory every time I execute a query. I am using the following code:

public  SqlCeDataReader ExecuteReader(string command, params SqlCeParameter[] commandParameters)
        {
            SqlCeDataReader reader = null;
            SqlCeCommand c = new SqlCeCommand(command, cn);
            try
            {
                for (int i = 0; i < commandParameters.Length; i++)
                    c.Parameters.Add(commandParameters);
                reader = c.ExecuteReader();
            }
            catch
            {
                // Release resources
                c.Parameters.Clear();
                reader.Close();
                throw;
            }
            c.Parameters.Clear();
            return reader;
        }

This method is a part of my 'SqlCeHelper' class that I have written.

I noticed that when I reach the line reader = c.ExecuteReader() , the memory of my device decreases by about 1%. The reader is returned to a class which makes use of it and then disposes of it by calling reader.Close(); The connection to the database is also closed properly at some point, but memory never gets released. Memory gets only released when the application terminates.

I am wondering if I am doing something wrong by not disposing of some resources. Please help!

(Also tried GC.Collect() , didn't help!)

Cheers.

View Replies !   View Related
SqlCe Database Corruption
Hi; there;

      I know that power failure can corrupt a sdf file (http://support.microsoft.com/kb/296076/en-us)

      Apart from that, is there any other reason can corrupt a SqlCe2.0 sdf database?

 

Another problem I found in my sdf database is corrupted record. There is a record in the database has all field with "null" value. When I tried to compact this database in "Query Analyzer", it has cursor there forever. I can still open the database and view those record. I tried to delete this record by saying "delete from job where ... is null", that database is fixed!!! I can compact that dataase again.

Note: I have transaction when writing data to database and my application has quite a lot database corruption issue which is nightware now.

 

    Does anybody know what causes this and how to avoid this problem?

 

   

View Replies !   View Related
SQLCE Sync To Two Server???
how can one ce database sync to two different server?

for example, i sync ce to server A, also i would like to sync to server B.

And the other case how can i re-sync ce data to same server if server has some data lost??

View Replies !   View Related
Issue With SqlCeParameter (SqlCE 3.1)
 
Hi,
I have a simple query as follows:
 
SELECT COUNT(ID) FROM AI_DTREE DT WHERE PARENT =@pPID AND
CARTRIDGE_ID = @pCID  AND COMMAND =@pCMD AND OBJECT =@pObj
 
Where @pPID=16700130,@pCID=43000000,@pCMD=€?=€?, and
@pObj=€?the cecum, identified by appendiceal orifice & IC valve€?
 
The filed OBJECT in AI_DTREE is of nvarchar(30)(of course the length of @pObj is more than 30 in my current query).
 
 
I have build the SqlCeCommand sccmd object with the above sql text and the parameters.
 
returnval = sccmd.ExecuteScalar();
When I execute the above statement I am getting the following error:
 
ex.Message = "@pObj : String truncation: max=30, len=55, value='the cecum, identified by appendiceal orifice & IC valve'."
 
But when I execute the same in Sql Server Management Studio against SqlCE db, it works fine and the result returnval =0.
 
How to overcome this SqlCeParameter issue?, for me it is difficult to messure the length of the filed before I exeuting the command.
 



Thanks

G Sreenaiah

View Replies !   View Related
Compact Sqlce Database
Hi, there;

      I got a SqlCe2.0 database here called JOB.sdf, size is 260K. When I tried to compact it, it took very long and that JOB.sdf.tmp was created with 27.7M!!!, I can still open table in the database, but I found that there is some invalid data (unreadable square boxes). It looks like database was corrupted. My application gave error:

Error Code: 80040E14
 Message : The OLE DB Execute method failed. The SQL statement is not valid. [,,,SQL statement,,]
 Minor Err.: 28560
 Source : Microsoft SQL Server 2000 Windows CE Edition
 Error Code: 80040E14
 Message : Line 1: Incorrect syntax near 'ࠁ缂¬Ã©€™€°Ã¬±´ÃªÅ ®Ã£¶»Ã¤¡Æ’ꢀ¹Ã¨Å¸¬Ã£³Å¡'.
 Minor Err.: 170
 Source : Microsoft OLE DB Provider for SQL Server
 Error Code: 80040E14
 Message : Unclosed quotation mark before the character string 'ࠁ缂¬Ã©€™€°Ã¬±´ÃªÅ ®Ã£¶»Ã¤¡Æ’ꢀ¹Ã¨Å¸¬Ã£³Å¡'.
 Minor Err.: 105
 Source : Microsoft OLE DB Provider for SQL Server</E>

 

Note: " " is displayed as "SOHSOH....." with black background.

 

Apart from compacting database, is there manual job or tool we can do/use to fix a corrupted database caused by power failure? (e.x: all data saved successfully before power failure)?

 

Thanks

View Replies !   View Related
How To Rename A Column In SqlCE?
When I execute EXEC sp_rename 'PATHSPECIMEN.PVVALUE', 'PVPROC', 'COLUMN', I am getting the following error:
Major Error 0x80004005, Minor Error 25621
> EXEC sp_rename 'PATHSPECIMEN.PVVALUE', 'PVPROC', 'COLUMN'
The specified argument value for the procedure is not valid. [ Argument # = 3,Name of procedure(if known) = sp_rename ]

Could some one guide me where I am wrong?
I am executing this query against SqlCE in Sql Server 2005 Management Studio.

View Replies !   View Related
Private Deployment Of SQLCE For C++ App
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 Replies !   View Related
SCOPE_IDENTITY() SqlCe Problem
I unable to do the SCOPE_IDENTITY on a insert query at SQL Mobile.

 

I need to perform on this query the insert on Client table and to get the ID.

I am programming on Visual Basic on Visual Studio 2005

 

My code is:

 

Dim ClientID as Integer

Dim sql As String = "INSERT INTO Client(Number) VALUES('5'); SELECT scope_identity()"

Dim cmd As New SqlCeCommand(sql, connection)

 

connection.Open()

ClientID = Convert.ToInt32(cmd.ExecuteNonQuery())

connection.Close()

 

And I get an error like this:

 

There was an error parsing the query. [ Token line number = 1,Token line offset = 76,Token in error = SELECT ]

 

Thanks!

View Replies !   View Related
SQLCE - Getting Started Questions....
I am trying to soak in all this information regarding SQLCE and was hoping someone could set me off in the right direction.

Scenario:
I have an Windows Mobile 5.0 data collection application that I need to sync with a desktop database.  I will need the ability to sync 1 or more Pocket PC's with a desktop database. 

Questions:

1.) Assuming I need to sync the data, is using a SQLCE database on the device AND the desktop a viable solution?

2.) If  not, would my only other option be to use SQL Server Express (SQL Server is not an option, $$$)?

3.) Keeping simplicity in mind, what would be my best choice of syncing technology?  RDA?  Merge Replication? Microsoft Synchronization Services for ADO.NET?

Generally speaking, I want to know if YOU were starting from scratch,  what combination of technologies would you use?

Thanks!!!

Mike

View Replies !   View Related
Trying To Get Jpg Image Saved To Sqlce Db
I'm trying to get this logic to work in vb.net.  I keep getting errors on assigning the value of the image to the parameter.  Also, how do you do the reverse and retrieve it from the sqlce db into a picturebox?  Any help is greatly appreciated.  Thank you.

Dim value As ImageFormat

Dim imageBytes As Byte()

Dim cn As SqlCeConnection

Dim strSQL As String

Dim cmd As SqlCeCommand

value = ImageFormat.Jpeg

Dim ms As New MemoryStream()

pbxPhoto.Image.Save(ms, ImageFormat.Jpeg)

imageBytes = ms.ToArray()

cn = GetConnectionStart(cstrSQLCeFileName)

strSQL = "UPDATE BaltPhoneDir Set Photo = Values (?) LName_1 LIKE '" & strLastName & "' AND FName_1 LIKE '" & strFirstName & "'"

cmd = New SqlCeCommand(strSQL, cn)

cmd.Parameters.Add("@image", SqlDbType.Image, imageBytes.Length)

'cmd.Parameters

'cmd.Parameters["@image"].value = imagebytes

cmd.Parameters.Add(imageBytes)

cmd.ExecuteNonQuery()

View Replies !   View Related
Execution Plans - SQLCE 3
Does SQLCE 3 cache execution plans? Or even make use of them?

Thanks

Tryst

View Replies !   View Related
Connect From Sqlce 2.0 To Sql Server 2005
I want to connect sqlce 2.0 to sql server 2005. From "Connectivity Tools for SQL Server Compact, SQL Server Mobile, SQL Server 2000, and SQL Server 2005", I know I should install sql server 2005 without the replication components. I do it, then i find i can not create publication. Without replication, how can i synchronize between sqlce 2.0 and sql server2005?

Anyone can help me?

Thirst for your answer.

 

View Replies !   View Related
Problem Loading A Sqlce Table
I've got a db table, that I created in Sever Studio Management and I can se all the data and everything the
problem is that when I load it to the movile device (windows mobile 5.0) it says that the table is NotAble
but in the management works fine, I can't even do a "select * from table", and if you check the query analyzer
you se the table but it has no columns.

View Replies !   View Related
Having Problem Connecting To Sqlce DB On My Device..
I'm getting the following error when trying to connect to the sqlce database on my mobile device.
"Specified SQL server not found: (Program FilesDBA_test.sdf)"

The DB file exists in the directory specified and is in working order I was able to run a simple sql query against it (SELECT * FROM A_Test). So, I'm a little confused on how to correct this problem??? I'm assuming it's some type of mapping issue with the program and the DB but I'm not sure how to correct..


 


Code Snippet

   Public Function DB_Dataset() As DataSet   'returns a dataset with query results
        ' Make the database connection.
        Dim myConnection As SqlConnection = New SqlConnection(GetConnectionString())

   'Open the connection


        myConnection.Open()
        'Open a set of records
        Dim ad As SqlDataAdapter = New SqlDataAdapter("SELECT [names] FROM testtable", myConnection)
        Dim ds As DataSet = New DataSet()

   'Close the connection


        myConnection.Close()
    End Function

    Private Function GetConnectionString() As String
        Return "Data Source=(" & apppath + "DBA_test.sdf);Database=A_test; Integrated Security=SSPI;"
    End Function
Also since there's a DataSet that contains the connection information shouldn't I be able to access this directly instead of having to supply the connection information in a connect string?

Thanks.

View Replies !   View Related
SQLCE Synchronization Solution Recommendations
 

 
I create data collection applications on Mobile Devices for field biologists.  The biolgists need to sync thier field data with a local database upon returning from the field.  I am planning on using sqlce as my mobile database and am trying to get a grasp of what my synchronization options are.  Here are some of my questions.
 
1.)  Is there any way to synchronize data between a SQLCE database on the mobile device and a SQLCE database on the desktop (third party or othewise)?  It appears to me that the answer is no, which is a shame.  Whats the use of having a free light weight database that you can use on a mobile device and as a backend on a desktop but not sync data between them? 
 
2.) If my hunch is right, what are my sync options?   Installing SQL Server on every field computer is not an option ($$$).  If I'm bound to using SQL Server as the backend database, is it possible to have a single SQL Server database on a webserver that the field locations could sync to remotely? 
 
Any feedback to get me started in the right direction would be greatly appreciated.
 
Mike
 
 
 
 

View Replies !   View Related
Read/Write Operation On SQLCE 3.0 Using VC++
Dear All,
 
I am looking for a sample code to do read/write operation on SQLCE 3.0 using VC++. For SQLCE 2.0 I have used ATL Consumer template and works well.
 
Thanks in Advance.
 
Param

View Replies !   View Related
Migrate SQLCE Code To MAC Machine
 How to port port SQL CE code to Mac OS

View Replies !   View Related
Resetting Sqlce Forgot Password
 

can we reset sql server CE forgotten password ?
 
 
Regards
Mukesh Gupta

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved