SqlCeException thrown by SqlCeRemoteDataAccess

  • Thread starter Thread starter Oshiko
  • Start date Start date
O

Oshiko

My problem is, I can use SqlCeRemoteDataAccess to pull the data
successfully. But when I use SqlCeDataAdapter to retrieve data to Dataset,
the SqlCeRemoteDataAccess will throw 27750 SqlCeException.


The code is like this, the exception will throw during the creation of
SqlCeRemoteDataAccess. Please help. Thank you.

if(this.dataSet == null)
this.dataSet = new DataSet();

// Remove the table if it is existed.
if(this.dataSet.Tables.Contains(this.tableName))
this.dataSet.Tables.Remove(this.tableName);


GetDataSet(this.dataSet, this.localConnectionString, this.tableName,
"Select * From Accounts", "AccountID");

this.dataRows = this.dataSet.Tables[this.tableName].Select("LocalID =
0");

SqlCeRemoteDataAccess rda = null;

try
{
rda = new SqlCeRemoteDataAccess(this.internetUrl,
this.localConnectionString);
}
catch(Exception ee)
{
MessageBox.Show(ee.Message);
}



**************************************

public void GetDataSet(DataSet dataSet, string connectionString, string
tableName, string selectCommandText, string[] primaryKeys)
{
SqlCeConnection connection = new SqlCeConnection();

connection.ConnectionString = connectionString;
try
{
connection.Open();

SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(selectCommandText,
connection);
try
{
dataAdapter.Fill(dataSet, tableName);
SetPrimaryKeys(dataSet, tableName, primaryKeys);
}
catch(Exception e)
{
string a = e.Message;
}
finally
{
dataAdapter.Dispose();
}
}
catch(Exception e)
{
string a = e.Message;
}
finally
{
connection.Close();
connection.Dispose();
}
}
 
I discovered that if the dataset return from the DataAdapter is
huge(i.e.5000 records), the SqlCeRemoteDataAccess will throw the 27750
error.
 
Hi Chee,

How much memory does your device contain? The 27750 error is returned when
SQL Server CE cannot load sscemw20.dll or ssceca20.dll is missing or not
registered. Is it possible that the device is running out of memory?


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: Chee Hong Wong <[email protected]>
References: <#[email protected]>
X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
Subject: Re: SqlCeException thrown by SqlCeRemoteDataAccess
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <OkKi#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
Date: Thu, 07 Aug 2003 19:06:55 -0700
NNTP-Posting-Host: actionjackson133.dsl.frii.net 216.17.147.133
Lines: 1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:30448
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I discovered that if the dataset return from the DataAdapter is
huge(i.e.5000 records), the SqlCeRemoteDataAccess will throw the 27750
error.
 
Back
Top