help:my db server is oracle based on unix box, how could i use sql server ce to connect it?

  • Thread starter Thread starter stone zou
  • Start date Start date
S

stone zou

Hi, our db server is oracle based on unix, what db i could use in Win
CE.net?
or how i could get the data from db server?
thanks.
 
Use a web service. The web service can run either on Unix box using one of
the Unix implementations or you can host it on the Windows box and use
managed provider for Oracle. Web service can return a DataSet object that
can bea easily used on the device side
 
hi,thanks for your reply.but i dont't want to use a browser since i use grps
to connect the db server , and the speed of grps is slow. depending on your
reply, my question is
1>if the sql server ce only could use to connect SQL server?
2>could th sql server ce used to connect other db server running on Windows
platform?
3>since i don't use browser, should i use a socket to connect to Web
service?
thanks again
 
why do you speak of browser ?
FYI WebServices is just a text based and type unsafe high level
communication protocol which is slow but multiplatform and run on CF (unlike
remoting).
Of course WebServices run over socket, but using WebService is like calling
a method, much abstraction on top of the socket, obviously

to answers your questions:
1> Sql server ce connect to Sql server
2> Sql server ce connect only to Sql server
3> Sql server, oops, yep you use a socket to connect to the web services,
but don't worry about it, it's all handled by the WebServices architecture
.....
 
thanks,your reply is helpful. i used to understand WebServices running on
Server,
according to your reply, WebServices is running on embedded services which
use to get data from server?
 
You confused me.

let's say it other wise.
you host the web services on the server and you call it from your client
application.
from the code point of view you will just call an ordinary method, but, uh..
wsld.exe ? something like that would generate for you the proxy code (at
development time) wich transform you method call into a web services call.

does it make sense to you ?
 
Back
Top