ADOCE for VB.NET

  • Thread starter Thread starter Gareth Davies
  • Start date Start date
G

Gareth Davies

Hello,

Can anyone tell me if its possible to use ADOCE when
writing a VB.NET application for the compact framwework. I
am trying to write the application for a Windows CE.NET
device.

Is ADOCE avaliable for .NET development? I can't seem to
find anything anywhere.

Overall I am trying to make a direct connection to a
Oracle database over 802.11b. To simple valiadate some
barcodes.

Any ideas?

Thanks

Gareth
 
Because ADOCE is an ActiveX control and these are not directly supported by
..NET Compact Framework it is necessary to have a wrapper which exposes the
ActiveX functionality as static C methods which can then be consumed from
..NET CF code. We have a solution which combines this with a rich .NETCF
class library over the top of the functionality so it works like any other
ADO provider - http://www.inthehand.com/dotnet/adoce/

However if you aim to connect to a remote database you will need to consider
a different approach. In the absence of an Oracle Server provider for .NETCF
you will need an alternative method of communicating back and forth with the
database over your network. One way of achieving this would be to implement
webservices on a PC or server on your network. This machine would
communicate with Oracle using the support available in the full framework
and expose webservice methods specific to the business processes you wish to
support. You can then reference this service from your device application
and call the services to send/receive data. This article about creating the
"Task Vision" application may be useful in this scenario
http://smartdevices.microsoftdev.com/Learn/Articles/637.aspx


Peter
 
Thanks for your immediate reply....

Would you advise to go down the Embedded Visual Tools 3.0
route and use ADOCE with VB. Do you think it will be
possible to use ADOCE to make a connection to an Oracle DB.

The DB is a Call Stored Procedure we only want to display
its value.

Thanks

Gareth
 
ADOCE only allows for working with local databases (Pocket Access, Sql
Server CE and any third party ole-db providers that are available). I don't
think there is a way you can use ADOCE with a remote Oracle server -
possibly if you use Oracle Lite on the device but if you just want to return
a single value a webservice would be a better option.

Peter
 
Hi,
take a look at www.devbuzz.com for an article on accessing remote databases.
There is a client and server provided, and the it should be a breeze to make
it work with oracle. I tested it with access, mysql and sqlserver, and know
someone got it working with informix quite easily

Pete
 
Back
Top