From: Tyrone Omidi <tyrone@sbsworldwide.com>
To: pgsql-interfaces@postgresql.org
Subject: Help with pgsql / Access
Date: Tue, 30 May 2000 12:39:47 +0100
Message-ID: <HGEHIMIBLNNBPLIHFCJEKEEGCDAA.tyrone@sbsworldwide.com> (raw)
Hi,
Looking for some basic info using Access as a front end to PostgreSQL.
I know nothing of SQL (but willing to learn) and a little experience of
Access, lots of Unix/Linux.
I have doadloaded and installed the odbc driver, unticked all the readonly
stuff. (I'm using postgres 7 with Access2000 )
I have setup a system DSN. From within Linux I have created a user, a
database and made changes to the pg_hba.conf file.
My problem is I don't know how to connect Access to postgres now this is
setup.
I found some info as below.
Create a new Access file, select queries, click new, close show table dilog,
from query menu select SQL specific & pass-through. Select odbc source and
click ok. ( At this point all seems well and asks to save password )
I did try a few SQL commands in the passthrought box but it comes up with
"ODBC-call failed error creating the table ps(#17)
What I was thinking here was that I could create, change tables to store
data, it would save to postgres and using Access as a front end many people
could get access to it ?? Do I have the wrong end of the stick, is there
more to it. Unfortunatly I can't find any basic info this.
Any help appreciated
Thanks
very newbie
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tyrone@sbsworldwide.com
Subject: Re: Help with pgsql / Access
In-Reply-To: <HGEHIMIBLNNBPLIHFCJEKEEGCDAA.tyrone@sbsworldwide.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox