Re: [ODBC] Windows CE - Mailing list pgsql-interfaces

From Dave Page
Subject Re: [ODBC] Windows CE
Date
Msg-id AA30E7BCCA5C1D4E88A231900F8325C00C27@dogbert.vale-housing.co.uk
Whole thread Raw
List pgsql-interfaces
I'm sure it's possible, though M$ designed CE to work the way I described
afaict, so I imagine it would take a great deal of work.

You would obviously need an app to listen on the IR port on the PC (btw. IR
ports on Win98 work totally differently from those in 2K/XP - as I recall,
in 98/ME they emulate serial ports, whereas in 2K/XP they are network
devices) and translate between the ODBC driver and CE device. I doubt you'll
be able to tie it in with ADOCE, so you'll need to build suitable
recordset/connection classes on CE, and you'll obviously need to design a
communications protocol...

Like I said, a *lot* of work. If you do it though, it'd be great if you
would make it open source - I would probably find a good use for such code
for one.

Good luck,

Regards, Dave.

> -----Original Message-----
> From: Paul Jarosz [mailto:paul_jarosz@moduletech.com] 
> Sent: 30 October 2001 21:11
> To: Dave Page
> Subject: Re: [ODBC] Windows CE
> 
> 
> 
> The thing is that I need real time access to the postgres 
> data via wireless network.  I had this thought in the back of 
> my head to write an API for the CE device to access the ODBC 
> driver on a workstation using sockets.  Do you think this is 
> a feasible idea?  Or do you have an easier idea/suggestion?  Thanks...
> 
> Paul
> 
> ----- Original Message -----
> From: "Dave Page" <dpage@vale-housing.co.uk>
> To: "'Paul Jarosz'" <paul_jarosz@moduletech.com>; 
> <pgsql-odbc@postgresql.org>
> Sent: Tuesday, October 30, 2001 3:52 PM
> Subject: RE: [ODBC] Windows CE
> 
> 
> 
> 
> > -----Original Message-----
> > From: Paul Jarosz [mailto:paul_jarosz@moduletech.com]
> > Sent: 30 October 2001 03:28
> > To: pgsql-odbc@postgresql.org
> > Subject: [ODBC] Windows CE
> >
> >
> >
> > Is there a version of the ODBC driver for 
> PocketPC/WindowsCE?  Has it 
> > be attempted or even possible?  I love Postgres and it 
> would be really 
> > great to access my data from a handheld.
> >
> > Paul
> >
> 
> No, this is not possible. I've researched this a bit and 
> written CE code for Informix & PostgreSQL applications and 
> basically the trick is to use M$ Activesync to synchronise 
> between Pocket Access .cdb files and the ODBC datasource on your PC.
> 
> In both of my apps, I actually found it was much easier to 
> build the databases in an Access .mdb file on the PC (using 
> whatever queries are required to get the data from the real 
> server, and code to munge it into a suitable format). I then 
> transfer the .mdbs to and from the device.
> 
> I have apps working this way to allow building surveyors 
> download their workload, visit buildings and then upload the 
> results (from/to an Informix system), and for Scheme Managers 
> (kind of social workers) to download case files and log 
> visits to people on a PostgreSQL system.
> 
> Regards, Dave.
> 
> 


pgsql-interfaces by date:

Previous
From: Christof Petig
Date:
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement
Next
From: Bruce Momjian
Date:
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement