Re: MS-Access in PostgreSQL ... I can ´t...

Topo,

Question: What EXACTLY are you trying to do? Quick recap, there's

* PostgreSQL (running under Cygwin)
* PostgreSQL ODBC driver (separate download/install)
* pgAdmin III (latest/greatest Windows GUI client front-end...
to PostgreSQL ONLY!)
* MS Access (version?)

The more details you provide, the better. For example, what versions do
you have of each of the above? What about Cygwin, what version are you
running of that? Have you done the basics, like installing PostgreSQL
and making sure it works properly by itself, using the pgsql client CLI?

If you're working with computers, you really need to get into a clean,
straightforward methodology on troubleshooting to make sure you have all
the pieces in order. In the case of PostgreSQL, always be sure the
basics work (using just the PostgreSQL tools themselves), and only then
start trying to plug in more complicated things like pgAdmin III, or MS
Access (which in turn requires using the pgODBC driver).

What are you really trying to do here? Are you trying to store data in
a PostgreSQL database, then hook into that data using MS Access as a
sort of front-end? If so, you need to make sure of the following, in order:

* Is PostgreSQL itself working ok? Can you use pgsql to connect to and
communicate with PostgreSQL? How is PostgreSQL configured, using
internal sockets and/or TCP/IP?

* Have you downloaded/installed the appropriate pgODBC driver for your
version of PostgreSQL? I believe you normally just want to have the
latest installed, but check the docs.

* Have you gone into your ODBC control panel and created an ODBC
connection to your PostgreSQL database, making sure to use an
appropirate username/password/etc.?

Your email does not provide enough detail regarding what it is you have
done, what it is you are doing, what versions of software you are
running, etc. The more info you provide, the better chance you have
that someone on this list will understand your problem and the more
likely you'll get a response that helps you.

Topo Gigio wrote:

> I tried, but I can´t.
>
> I just installed MDAC from Microsoft, but I can´t connect MS-ACCESS. When I clicked in button Connect,
> nothing to do, only my screen blink. This screenshort show me:
>
> DataSource: I put my OBDC Connection
> Below, show me: driver, driver version, user, server name (ACCESS), etc.
>
> Please, Could you help me, please?
>
> Thanks and Regards.
>
> Topo_Gigio
>
> ------- Original message -------
> From: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
> Date: Thu, 8 Apr 2004 10:20:56 +0200
> Subject: Re: [CYGWIN] MS-Access in PostgreSQL ... I can ´t....
>
> Hello,
>
> Am 08.04.2004 um 03:45 schrieb Topo Gigio:
>
>
>>Hello,
>> I need to connect MS-ACCESS inside my PGADMIN (Postgresql). I
>>used Tools>, selected database (directly or by ODBC), clicked button
>>connect, but doesn´t appear nothing, nothing
>>to do.
>>
>> For example: I´ll read tables from MS-ACCESS, filter some
>>fields(data) which need, load on PostgreSQL.
>>Important, I need read the data from database MS-ACCESS, not only
>>structure. Anyway, Select and Insert? I
>>can?
>
>
> You can connect to Postgres database tables from within Access (linked
> ODBC tables).
> Then you can do "Queries" in Access and select/copy the data as you
> like.
>
> I think you cannot connect to an Access database (or any other database
> except Postgres) from
> PG-Admin, since that is designed specifically for Postgres.
>
> Best regards,
>
> Christof Glaser