RE: RE: RE: ODBC and Access 2000

Hello,
To run Cygwin on NT just go to www.cygwin.com and follow the
instructions. The latest version of cygwin includes postgresql 7.1.1 (I
don't know wether this has been patched to for the plpgsql bug). You could
also compile it from source. See the FAQ's, and for more on using postgresql
with cygwin look to pgsql-cygwin (I'll just say 98 will do for development,
but don't try to run it for production, it's far to unstable and I've never
got it to pass regression tests, NT seems far better, but I don't think its
as speedy as Linux for this (no facts, just impressions), and I have nio
idea for othe unices (unixes?)).
The easiest way to get postrgesql to work with Access is to use
linked tables. To do this first put the ODBC driver on (
ftp://ftp-stud.fht-esslingen.de/pub/Mirrors/ftp.postgresql.org/pub/odbc/vers
ions/ and go to either full, msi, or dll to get 7.01.0005 (full is probably
the one you'll need)). See my post a short while ago (or any number of
others) for info on my settings. Then just in access select new table, link,
and then select the ODBC settings (you'll need to have setup a DSN, have a
look at http://techdocs.postgresql.org (definitely have a look here LOTS of
good info) for more info or the FAQs). I tend to not use DSN's and
CreateTable with all the settings in a string to dynamically create tables
(which is why I gave a connection string like I did).
There's quite a bit of info in various FAQ's and previous mailing
list discussions on this type of issue (and the various problems),
particulary look at the ODBC settings (e.g. you'll need to turn of the read
only both the driver and the datasource options to get a writable version).
Hope this gives you somewhere to start at,
- Stuart

> -----Original Message-----
> From: kapil c. tilwani [SMTP:tilwanis(at)rediffmail(dot)com]
> Sent: Friday, May 11, 2001 7:00 PM
> To: peterw(at)innate(dot)co(dot)uk; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: RE: RE: ODBC and Access 2000
>
>
> Hi,
>
> My name is Kapil.
>
> I am working on a small project in VB and currently using MS-Access as my
> db. I wanted to upgrade to Postgres as Access was getting slower and
> offered no triggers that were required. However, I learnt that PG works
> only on Linux. However, I have also learnt that it does work on NT after
> Cygwin et al... I believe you are using VB and PG ... If possible, could
> u just tell me as to how has that been achieved...
>
> If possible, could u kindly be a bit descriptive as that could help...
> both in terms of installation of Postgres and using Postgres in VB.
>
> Waiting for ur early reply,
> Thanx in advance,
> Kapil
>
> PS : Found ur mail address thru PG community mail...
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>