Re: Need realy help! Nobody there who knows a solution for my memory-error on WM5??

Hello!

Where did I set the database size? When it is in the Connection-String
You can see that I've set (max buffer size) on 4096. Is there an other
parameter I've to set?

Why are the Problems only on the wm5 and not on the wm2003 devices?
It's the same sourcecode only the compiler is switched to the devices.

The "trick" with closing and reopening the database i will try, but i
think this is not the realy right way for a database application.

Are there any good samples in the web or in Books special for PPCs
where i can compare my sourcecode with?

René


On 12 Apr., 18:05, "William \(Bill\) Vaughn"
<billvaRemoveT...@xxxxxxxxx> wrote:
I think Mr. Vickers is on the right track. I expect that you are not freeing
memory between operations. However, another thought occurred to me: Consider
that unlike SQL Server, the Compact Edition does not compress until the last
connection is closed. How about closing the connection and giving the engine
a chance to compress out the dead space. How large did you set the database
size? The default is 128K.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speakerwww.betav.com/blog/billvawww.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visitwww.hitchhikerguides.netto get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
---------------------------------------------------------------------------­--------------------------------------------


.

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How To Add/Update Record In ADO.NET
    ... If the row is already there (there is already someone with the same name in the database), ... Hitchhiker's Guide to Visual Studio and SQL Server ... "Jeff Gaines" wrote in message ... SQL Server Compact Edition or Express Edition come to mind. ...
    (microsoft.public.dotnet.framework.adonet)
Loading