Oracle connectivity for CF

[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

 

[Ginny Caughey [MVP]]

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

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 ?

 

[William Ryan eMVP]

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.

Yeah I've though about this solution already, but its too heavy for what

the embedded application is doing.

Plus I have some complication because I already have a web service running

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.

 

[Ginny Caughey [MVP]]

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

Yeah I've though about this solution already, but its too heavy for what

the embedded application is doing.

Plus I have some complication because I already have a web service running

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.

 

[Guest]

because Oracle lite use a web service and data synchronisation that need dedication of the DB which is not possible with my system.