Oracle DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to work directly to Oracle DB from a .NET CF application for a
wireless scenario?

Thanks

Tony.
 
Encapsulate database access to Oracle as a set of Web Services running on
the server.

Leverage those web service from your CF app.

There is also a version of Oracle that runs on Pocket PC, but I have no
experience with it
and don't know if it provides managed assemblies for local or remote
database access.

-Darren Shaffer
 
At this point, I believe Darren's suggestion is the only way to maintain a
real time interface betweeen oracle and the CF.

Supposedly there may be direct access added; Even if they do add it,
however, the web service is a much, much better way to go and will be more
scalable for you...

AFAIK, the Oracle DB for Pocket PC works exactly like ActiveSync, MSAccess,
and Pocket Access. The db resides on the handheld and it is transactionally
synchronized during a synch process. It does not allow for a connection to
a db sitting out on some server somewhere (even though your pocket PC may be
linked, wireless or tethered, to the network)

Somebody correct me if I'm wrong on that last statement, but your best bet
is the WebService. It's a little intimidating for the first time, but once
you recognize what is going on, it's just as easy as having the direct
connection....
 
Hi,
take a look at SqlLink CE on our site - we support Oracle access, but you
need our middleware (supplied) on a PC

Pete
 
if I configure Oracle DB as a Linked Server from SQL Server?... Will we have
an access to manipulate the data (insert/modify/delete)....?

Thanks again for your support.
 
Do you mean you want to use SqlClient namespace to connect to
an intermediate SQL Server, and execute SQL statement to the
Oracle DB which is set as linked server?

That's interesting, I didn't try that, but you can...

However, you might involve SQL Server license affairs...

--

Best Regards,

Jan Yeh
MVP - Windows CE.NET, MCSD.NET, .NETcf consultant
http://blog.mvpcn.net/janyeh
 
Back
Top