Re: Access DataBase on PocketPC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: George Shubin (dx_at_dxonline.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 09:23:48 -0700

From: http://www.inthehand.com/index.php?page=5&show=1,2

"The Compact Framework contains data providers for SQL Server CE and a
remote SQL Server, it also allows access to data in XML text files. There is
no support for Windows CE Property Databases (.cdb - often known as Pocket
Access).

"ADOCE In The Hand plugs this gap by providing read/write access to Windows
CE Databases from the .NET Compact Framework. You can also access system
tables in the Object Store. It supports the full functionality of the Pocket
Access database engine including long Binary (BLOB) fields. It uses an
object model which will be familiar to eVB programmers while taking
advantage of new .NET features such as Data Binding with the DataGrid
control as you would expect from a .NET DataTable object."

I have no direct experience with this product or the company, but I was
aware of it, and thought you'd like to know about it as well.

Regards. 

-- 
------------------------------------------------------------------------
George Shubin       Custom Software Development
dX Software Systems          Database Applications
Ph: 503-981-6806                     Fax: 503-982-0120
www.dxonline.com              george@dxonline.com
------------------------------------------------------------------------
"Gray Day" <D.Siegersma@gmail.com> wrote in message 
news:cku5r0$opi$1@news1.zwoll1.ov.home.nl...
> Hello,
>
> In eVB I made a simple application for my PocketPC (2003) that made
> connection with a (converted) access database. I'm now trying to write the
> same application in VB.NET. I just can't figure out how to make the
> connection with the database. I tried connecting with the use of a
> connection-string, but it seems this is not supported for writing
> applications for a SmartDevice.  The syntax "Imports System.Data.OleDb" is
> also not allowed for a SmartDevice application. Can someone give me a clue
> please.......
>
> Douwe
>
>
>

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: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)