Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] Windows CE

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Paul Jarosz'" <paul_jarosz(at)moduletech(dot)com>, "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [ODBC] Windows CE
Date: 2001-10-31 08:08:37
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00C27@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: 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(at)moduletech(dot)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(at)vale-housing(dot)co(dot)uk>
> To: "'Paul Jarosz'" <paul_jarosz(at)moduletech(dot)com>; 
> <pgsql-odbc(at)postgresql(dot)org>
> Sent: Tuesday, October 30, 2001 3:52 PM
> Subject: RE: [ODBC] Windows CE
> 
> 
> 
> 
> > -----Original Message-----
> > From: Paul Jarosz [mailto:paul_jarosz(at)moduletech(dot)com]
> > Sent: 30 October 2001 03:28
> > To: pgsql-odbc(at)postgresql(dot)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

Next:From: Bruce MomjianDate: 2001-10-31 15:11:38
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement
Previous:From: Christof PetigDate: 2001-10-31 07:52:17
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group