Hello guys,

I want to connect to and edit ms access database. The oledb functionality is
not present for .NET CF. When I try to build the solution, it gives me an
error "are you missing an assembly reference?" PS. I am coding in C#

I would like to know if there is a way to connect ms access database, and if
there is a way then what is it?

If not, then how should I go about dealing with this problem?


A little info on my project - I am doing a vending machine project for my
senior design where I have to take out all the logic circuit and replace it
with some thing new. I am using EBOX 2300 as the main control board, which
will have signals coming in and out to control other modules of the project.
The database is for keeping pricing information, authorized user information
such as user name and password (we are implementing student id and rfid card
purchases), and other things.

MS Access is a desktop only database format. There was a very basic
companion format called Pocket Access support for which ended with Pocket PC
2003. There are ways of synchronizing Access with a supported device
database format (such as SQL Mobile) in the Access Database Synchronizer:-
http://www.microsoft.com/downloads/d...DisplayLang=en

You can then work with the data through the System.Data.SqlServerCe
namespace. Alternatively if you want to work with a server machine running
an Access database you'd need to implement a Web Services or Sockets server
which internally used OleDb and the full framework.

Peter

--
Peter Foot
Microsoft Device Application Development MVP
www.peterfoot.net | www.inthehand.com
In The Hand Ltd - .NET Solutions for Mobility

"Arsalan" <(E-Mail Removed)> wrote in message
news:17027AE3-08A5-4833-A82A-(E-Mail Removed)...
> Hello guys,
>
> I want to connect to and edit ms access database. The oledb functionality
> is
> not present for .NET CF. When I try to build the solution, it gives me an
> error "are you missing an assembly reference?" PS. I am coding in C#
>
> I would like to know if there is a way to connect ms access database, and
> if
> there is a way then what is it?
>
> If not, then how should I go about dealing with this problem?
>
>
> A little info on my project - I am doing a vending machine project for my
> senior design where I have to take out all the logic circuit and replace
> it
> with some thing new. I am using EBOX 2300 as the main control board, which
> will have signals coming in and out to control other modules of the
> project.
> The database is for keeping pricing information, authorized user
> information
> such as user name and password (we are implementing student id and rfid
> card
> purchases), and other things.

FYI, If you're considering the Access Database Synchronizer then I advice
you to make sure that it won't be deployed on machines running Vista. I've
been going through a long support case with Microsoft and the solution
requires fixes from the Vista, Windows CE, and SQL Server teams. A fix
probably won't be available until the release version of Vista SP1 and the
next release of ADS.

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com


"Peter Foot [MVP]" <(E-Mail Removed)> wrote in message
news:BFECA2C4-7749-418F-901A-(E-Mail Removed)...
> MS Access is a desktop only database format. There was a very basic
> companion format called Pocket Access support for which ended with Pocket
> PC 2003. There are ways of synchronizing Access with a supported device
> database format (such as SQL Mobile) in the Access Database Synchronizer:-
> http://www.microsoft.com/downloads/d...DisplayLang=en
>
> You can then work with the data through the System.Data.SqlServerCe
> namespace. Alternatively if you want to work with a server machine running
> an Access database you'd need to implement a Web Services or Sockets
> server which internally used OleDb and the full framework.
>
> Peter
>
> --
> Peter Foot
> Microsoft Device Application Development MVP
> www.peterfoot.net | www.inthehand.com
> In The Hand Ltd - .NET Solutions for Mobility
>
> "Arsalan" <(E-Mail Removed)> wrote in message
> news:17027AE3-08A5-4833-A82A-(E-Mail Removed)...
>> Hello guys,
>>
>> I want to connect to and edit ms access database. The oledb functionality
>> is
>> not present for .NET CF. When I try to build the solution, it gives me an
>> error "are you missing an assembly reference?" PS. I am coding in C#
>>
>> I would like to know if there is a way to connect ms access database, and
>> if
>> there is a way then what is it?
>>
>> If not, then how should I go about dealing with this problem?
>>
>>
>> A little info on my project - I am doing a vending machine project for my
>> senior design where I have to take out all the logic circuit and replace
>> it
>> with some thing new. I am using EBOX 2300 as the main control board,
>> which
>> will have signals coming in and out to control other modules of the
>> project.
>> The database is for keeping pricing information, authorized user
>> information
>> such as user name and password (we are implementing student id and rfid
>> card
>> purchases), and other things.
>

Thanks for your reply Peter.

I am using EBOX, which is a mini computer with a 200 MHz processor. The
Access database will be on the EBOX it self and the EBOX will be a server as
well. Any changes made to the database can be done through a website, which
my team member is developing. He knows ASP programming and wants to stick
with MS Access. I don't know if I used SQL server, would the programming for
the website be any different. I guess that is the reason he wants to stick
with it, and anyways we don't want to install two servers on the EBOX, as it
will slow it down.

I also don't know anything about Web Services or Sockets server. I am just a
senior electrical engineering student, trying to do my senior design project,
lol.

Are there any OLEDB providers or wrappers made by people to handle this
functionality in .NET CF?

Thanks



The thing is that I want to stick with MS Access because my team member is
developing a website

There's no way to do this with Access. You need to use SQL CE. In either
case there's no access to the models through the ASP 3.0 server under CE
because there are no COM objects for that access. You'd have to create a
COM object yourself, and if you don't know anything but ASP, that's going to
be a major, major job (much harder than the rest of the entire project).


--

Chris Tacke, eMVP
Join the Embedded Developer Community
http://community.opennetcf.com


"Arsalan" <(E-Mail Removed)> wrote in message
news:79DC62A4-34FC-4CB4-B881-(E-Mail Removed)...
> Thanks for your reply Peter.
>
> I am using EBOX, which is a mini computer with a 200 MHz processor. The
> Access database will be on the EBOX it self and the EBOX will be a server
> as
> well. Any changes made to the database can be done through a website,
> which
> my team member is developing. He knows ASP programming and wants to stick
> with MS Access. I don't know if I used SQL server, would the programming
> for
> the website be any different. I guess that is the reason he wants to stick
> with it, and anyways we don't want to install two servers on the EBOX, as
> it
> will slow it down.
>
> I also don't know anything about Web Services or Sockets server. I am just
> a
> senior electrical engineering student, trying to do my senior design
> project,
> lol.
>
> Are there any OLEDB providers or wrappers made by people to handle this
> functionality in .NET CF?
>
> Thanks
>
>
>
> The thing is that I want to stick with MS Access because my team member is
> developing a website