Oracle connectivity for CF

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

Guest

Hello,
Like a lot of person, I need to access a Oracle DB 9.i from my Windows CE device, but I have no connectivity solution with Compact framework (such as System.data.oracleclient with classic .NET framework)

I really need this, my IDE is visual C#, and I have only found out how to connect to a SQL server

Moreover, I dont want to use the oracle lite synchronisation solution (which dont match my application requirements) so Im a bit lost atm

Is there any improvment or update I can expect from the CF which will introduce a connectivity with distant Oracle solution

Any one has coded its own driver yet and can share his/her experience in the subject

ty for any repl
 
I'd suggest writing a desktop web service app that you can connect to from
your CE device that also connects to your Oracle database.
--
Ginny Caughey
..Net Compact Framework MVP

dys said:
Hello,
Like a lot of person, I need to access a Oracle DB 9.i from my Windows CE
Click to expand...
device, but I have no connectivity solution with Compact framework (such as
System.data.oracleclient with classic .NET framework).
I really need this, my IDE is visual C#, and I have only found out how to connect to a SQL server.

Moreover, I dont want to use the oracle lite synchronisation solution
Click to expand...
(which dont match my application requirements) so Im a bit lost atm.
Is there any improvment or update I can expect from the CF which will
Click to expand...
introduce a connectivity with distant Oracle solution ?
 
You don't need it to be running on ASPX in order to consume a web service.
I agree with Ginny on this one. If you don't want that, why not use XML
Files and sync them up...once you deserialize them, you're working directly
with the dataset object.. I haven't found web services to be too heavy, and
I even run them off of my phone which isn't a powerhorse.

the guys at www.ihookdb.com wrote their own provider for MySql, depending
on your time frame, writing your own may be a viable option too.
dys said:
Yeah I've though about this solution already, but its too heavy for what
Click to expand...
the embedded application is doing.
Plus I have some complication because I already have a web service running
Click to expand...
on the server side, however it is dedicated to a J2EE web app (I wont get
into details, I suppose its not necessary, but I think it is not compatible
with c#/aspx since its not an IIS web server), thats why I need to find a
way to avoid the web service solution.
 
If you need to constantly update the data on both sides, and if a web
service won't work for you (I don't know if there is a problem between J2EE
and .Net web services or not) then the next solution to consider would be
one based on sockets. Here's a nice article that describes the concept:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncscol/html/csharp09182003.asp
--
Ginny Caughey
..Net Compact Framework MVP

dys said:
Yeah I've though about this solution already, but its too heavy for what
Click to expand...
the embedded application is doing.
Plus I have some complication because I already have a web service running
Click to expand...
on the server side, however it is dedicated to a J2EE web app (I wont get
into details, I suppose its not necessary, but I think it is not compatible
with c#/aspx since its not an IIS web server), thats why I need to find a
way to avoid the web service solution.
 
because Oracle lite use a web service and data synchronisation that need dedication of the DB which is not possible with my system.
 
Back
Top